"Gail Shaw" <initialsurname@sentech sa dot com> wrote:
> This works in SQL 2005
>
> SELECT tbl1.Col1, tbl2.col2 from tbl1 LEFT OUTER JOIN tbl2 on tbl1.Col1 =
> tbl2.Col1
>
> This doesn't
>
> SELECT tbl1.Col1, tbl2.col2 from tbl1, tbl2 WHERE tbl1.Col1 *= tbl2.Col1

I remember the Delphi programmers here at work squawking about that.  They have
a lot of embedded SQL in their Delphi code that uses the old latter syntax, and
they had to go thru and fix it all.  I guess that's why they get paid the big
programmer bucks :)

--
Dan
GoofyGraffix.com

Post a reply to this message