How to create a full join in database view

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!