Is there a way to do this query with SQLBase 7.6.1?

SQLBase 7.6.1

I have written a query that uses seven left joins to create a report. I've had some problems getting it to work.  Can someone verify that I am going down the right path and if there is a way to achieve the seven left joins using SQLBase 7.6.1?

 It started out like this sinice I come from SQL Server.

Select
    Whatever
FROM
    MainTable MT

    LEFT JOIN AnotherTable1 AT1
    ON MT.SomeField = AT1.Somefield

    LEFT JOIN AnotherTable2 AT2
    ON MT.SomeField = AT1.Somefield

    And so on five more times . . .

This didn't work.  I found from doing some reading that I needed to use this syntax.

Select
    Whatever
FROM
    MainTable MT,
    AnotherTable1 AT1,
    AnotherTable2 AT2,
    And so on five more times . . .
WHERE
    MT.SomeField = AnotherTable1.SomeField AND
    MT.SomeField = AnotherTable2.SomeField AND
    And so on five more times . . .

This worked but I realized it is the equivalent of using inner joins.  So I did some more reading and learned that by adding (+)  like this

Select
    Whatever
FROM
    MainTable MT,
    AnotherTable1 AT1,
    AnotherTable2 AT2,
    And so on five more times . . .
WHERE
    MT.SomeField = AnotherTable1.SomeField (+) AND
    MT.SomeField = AnotherTable2.SomeField AND
    And so on five more times . . .

I can get an outer join.  The problem is that it looks like I am allowed only one outer join.

Anway, sorry for the long description but I wanted to make my issue clear.

Any ideas?

Thanks,

ToddStart Free Trial