Full Outer Join?

[Pascal]

Hi all,

what is the symbol equivalent to FULL OUTER JOIN?

I tryed *=* but SQLServer doesn't support it.

thanks,
Pascal

 

[Elton Wang]

SELECT A.*, B.* FROM TABLE_A AS A FULL OUTER JOIN TABLE_B
AS B ON condition

HTH

Elton Wang
(e-mail address removed)

 

[William \(Bill\) Vaughn]

The "symbolic" syntax is obsolete and not guaranteed to be supported in
future releases. It's suggested that you stick with ANSI conventions.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Val Mazur \(MVP\)]

Hi,

I do not think there is *old* style syntax for the FULL OUTER JOIN. Actually
this syntax will be dropped in a SQL Server 2005, so there is no reason to
use it. Why do not you want to use FULL OUTER JOIN
syntax? If you are trying to make something more generic to cover multiple
databases, then using of the stored procedures could help you in this case,
moving database-specific code inside of the SP