How to create a full join in database view

[oacp]

Hi,

I am trying to create a full outer join in a database view.

The reason for this is that I want to display all records from three different tables for reporting purposes but there is no link that I can create in the 'where' clauses.

I just want all records from all three tables displayed with '(empty)' displayed in the columns where information is not present for that table.

I am not sure how to do this since I can only find the option to create a left join and as mentioned do not have much to link in the 'where' clauses. I have looked on the Wiki but it only provides information on left joins.

Thanks in advance!

[Community Alums]

Chris, do you know how to do a Left Outer Join on a DB view?  It seems to just be inner...

[COMPUNEX TECHNO]

NO!
That doesn't work. Database view doesn't allow you selecting other database view as a table.