Joins
Posted: Sun Oct 31, 2004 4:11 pm
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
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