Joins

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

Joins

Post 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 :)
Draco_03
Forum Regular
Posts: 577
Joined: Fri Aug 15, 2003 12:25 pm
Location: Montreal, Canada

Post by Draco_03 »

Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

Post by Steveo31 »

Nope, thanks Draco.
Post Reply