More than one outer join with SQLBase
Hi,
Most databases will not allow more than 1 Outer Join in a SQL query.
The secret though is to try to work in multiple queries and use a
Union. This should work in most cases, unless you intend to use an
outrageous number of Outer Joins. If you want to use two Outer Joins
then the Union will work.
--
--
Sincerely,
Brian Dong
To reply, remove nospam from the address.
Quote:
>Does anyone have any ideas how to work around the one outer join limitation
>of SQLBase?
