Full Outer Join Question

[FontanaS]

Can You Have Multiple On Sections In A Full Outer Join?
For Example, Is The Following Valid? -

Select *
From Table_A Full Outer Join Table_B
On Table_A.Field1 = Table_B.Field1 AND
Table_A.Field2 = Table_B.Field2

THANKS

 

[Tim1]

Hiya,

I am not quite sure which version of Sybase you are using, but I don't think that Sybase supports the "OUTER JOIN" syntax that you have used.

What should work for you is :

SELECT *
FROM Table_A A,
Table_B B
WHERE A.Field1 *= B.Field1
AND A.Field2 *= B.Field2

Tim