Outer Join of the requisition table and the candidate table?

Content

I would like an outer join of the requisition table and the candidate table. (Every record in the candidate table and every record in the requisition table, showing the join information where there is a join. And showing null data where there is no join.)

I do not think this is possible in TBE Insight Reporting. Anyone with thoughts on this

http://en.wikipedia.org/wiki/Join_(SQL)

Outer joins

An outer join does not require each record in the two joined tables to have a matching record. The joined table retains each record—even if no other matching record exists. Outer joins subdivide further into left outer joins, right outer joins, and full outer joins, depending on which table's rows are retained (left, right, or both).