List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 8 2000 6:58pm
Subject:Re: Join vs ,
View as plain text  
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
Thread
Join vs ,Richard Heyes8 Sep
Re: Join vs ,Paul DuBois8 Sep