left joins

[miz]

can some1 explain to me how is it work ?
i couldnt find the answer or understand the way its works.

[Dean C]

There's no point me explaining how just one join works. You might as well learn them all. Up until a few months ago I never understood how they worked but I knew which join to use at the right time. Take a look at this helpful article:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins/

And once you understand the basis of SQL joins you can look at how they work in MySQL in this other tutorial:

http://www.devshed.com/c/a/MySQL/MySQL-Table-Joins/

[sabret00the]

can some1 explain to me how is it work ?
i couldnt find the answer or understand the way its works.
if you do a search in here theirs a thread where Xenon teaches me left joins.

their actually quite easy, you simply find the cross reference (i.e. the data that is the same across the two tables, mostly that will be the record id number) and then use that to match up the data.