Page 1 of 1

Joins

Posted: Sun Oct 31, 2004 4:11 pm
by Steveo31
Having some trouble understanding MySQL joins. A few SQL commands I have stumbled my way through and luckily got the statement to do what I want. But, I'd like to know when such a thing is necessary.

I am taking various fields from tables and comparing like values in each, such as product names, ids, etc... but when I don't do the JOINS (mostly a inner join) it pulls them out multiple times.

Can someone explain joins and when to use them, etc? I've searched like crazy and they all say the same thing, which doesn't help :)

Posted: Mon Nov 01, 2004 11:21 am
by Draco_03

Posted: Tue Nov 02, 2004 8:47 pm
by Steveo31
Nope, thanks Draco.