Join?

[La_Parka]

I'm still somewhat new to MySQL, and was wondering what join queries do exactly? Do they join two tables that have a field in common?

If so, how do these compare to "WHERE table1.fieldA=table2.fieldA" statements, as far as ease and efficiency?

Edit: Typo

[OhLordy]

Depends what sort you use. There are basically three types of joins. Left joins, right joins and inner joins.
This sumarizes the theory quite nicely.
HTH
Rob

[La_Parka]

Originally posted by OhLordy
Depends what sort you use. There are basically three types of joins. Left joins, right joins and inner joins.
This sumarizes the theory quite nicely.
HTH
Rob

Thanks for the article. One question remains, though: which method would be the most efficient for querying the same rows---"Referring to Two Tables (as they refer to it in the article)," an INNER JOIN, or neither?

[tomhath]

It might depend on the DBMS, but generally the "Referring to two tables" and an inner join are the same thing.