Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Full Outer Join Question
- Thread starter FontanaS
- Start date
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
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
- Status