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