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: 353
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