Chris Sanford1
Kilo Guru

I think this might work for a full outer join of two tables:

  1. Create a database view of table1 left joined with table2
  2. Create a database view of table2 left joined with the database view from step1

For the third table repeat steps 1 and 2 where "table1" is your database view from step 1 and "table2" is your third table.

Haven't tried this but just a thought.

Another thought, you still do need a where clause for a full outer join, unless you want a complete Cartesian product. That would be very costly on performance. Three tables with just 100 records each would put you at 1,000,000 records. The formatting would also be bad with all the blank columns. A better recommendation, based on my understanding of your requirements would be a homepage with three separate gauges on it for the three tables.

I see this thread is very old but someone recently replied to it so it caught my attention, as I have thought about doing full outer joins in the past.