Re: Join vs ,

[Paul DuBois]

At 7:29 PM +0100 09-08-2000, Richard Heyes wrote:
>Is there any difference between using a comma or the word JOIN when listing
>tables in a query? Like so:

No difference.


>
>SELECT table1.col2,
>        table2.col2
>
>   FROM table1,
>        table2
>
>  WHERE table1.col1 = table2.col1
>
>
>vs
>
>SELECT table1.col2,
>        table2.col2
>
>   FROM table1
>   JOIN table2
>
>  WHERE table1.col1 = table2.col1


-- 
Paul DuBois, paul@stripped