February 10, 2004 at 2:49 pm
is *= a left outer join or right outer join?
thanks in advance,
Billy
February 10, 2004 at 2:58 pm
Left.
--Jonathan
February 10, 2004 at 3:32 pm
That is what I thought it was.
Thanks!
Billy
February 11, 2004 at 12:54 am
Only thing is it's legacy syntax, and not recommended to use (if possible)
If you're in a situation where you can choose, never use *= or =*syntax for outer joins.
Use the ANSI style instead.
SELECT foo
FROM table1 t1 LEFT OUTER JOIN table2 t1
ON t1.pk = t2.pk
There are many reasons not to use the legacy syntax, but the main reason is that as far as outer joins are concerned,
it's a fair chance that the results produced are actually not the expected ones..
(ie you get wrong results)
=;o)
/Kenneth
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply