More than one outer join with SQLBase 
Author Message
 More than one outer join with SQLBase

Does anyone have any ideas how to work around the one outer join limitation
of SQLBase?


Sat, 21 Feb 2004 11:45:08 GMT  
 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?



Sun, 22 Feb 2004 12:23:59 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. outer join with ACCESS

2. Access 2000 -Full Outer Join

3. Outer Joins

4. How DAO works with outer join query with Parameter

5. No outer joins with Jet 4 drivers?

6. sql poser: OUTER JOINS?

7. SQL Builder - Outer Joins.

8. E_FAIL when outer-joining

9. Ambiguous Outer Joins....

10. Access OUTER JOIN syntax

11. SQL Builder - Outer Joins.

12. E_FAIL when outer joining

 

 
Powered by phpBB® Forum Software