use of join in SQL

[jesussaves]

hey mates
I have a question regarding MySQL, can anyone tell me why do you use a join instead of doing something like:
CODE:

SELECT * FROM table1,table2 WHERE table1.column = table2.column

Is this about efficiency or does MySQL optimize joins better than it optimizes that "=" constraint. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[loraine]

That is a join. It's just not an explicit join. You should always use a proper join, as it's explicit cleaner and less likely to result in some Cartesian join funkiness and teh comma has a lower precedence, so do not add another table. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --