What's the different between these 2 mysql queries? one using left join

Posted by Lyon on Stack Overflow See other posts from Stack Overflow or by Lyon
Published on 2010-04-29T09:21:37Z Indexed on 2010/04/29 9:27 UTC
Read the original article Hit count: 351

Filed under:
|

Hi,

I see people using LEFT JOIN in their mysql queries to fetch data from two tables. But I normally do it without left join. Is there any differences besides the syntax, e.g. performance?

Here's my normal query style:

SELECT * FROM table1 as tbl1, table2 as tbl2 WHERE tbl1.id=tbl2.table_id

as compared to

SELECT * FROM table1 as tbl1 LEFT JOIN table2 as tbl2 on tbl1.id=tbl2.id

Personally I prefer the first style...hmm..

© Stack Overflow or respective owner

Related posts about mysql

Related posts about left-join