My table structure is as follows:

Main Table:
IdMain [key field]
MainField1
MainField2

SubTable1
IdSubTable1
IdMain
Sub1Desc

SubTable2
IdSubTable2
IdMain
Sub2Desc

SubTable3
IdSubTable3
IdMain
Sub3Desc

Each record in the Main Table can correspond to an entry in each of the three subtables. However, a record in the Main Table does not require a corresponding entry in any of the subtables.

I'd like to construct a query including LEFT OUTER JOINS which includes details from all of these tables, but I'm unsure of the syntax. The solution has to be compatible with Oracle 8 and above.