Duplication Results When LEFT JOIN is Used Between Multiple Tables
| From: | Mike Gifford | Date: | Wed, 11 Jul 2001 16:04:10 +0000 |
| Subject: | Duplication Results When LEFT JOIN is Used Between Multiple Tables | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-57406@lists.php.net to get a copy of this message | ||
Hello,
I'm making some headway on joining three MySQL tables. (Thanks to responses from this list early this morning)
However, when I run this query:
mysql_query("SELECT
WLPbib.bibID,
WLPbib.title,
WLPbib.publisher,
WLPbib.publicationDate,
WLPaddress.city,
WLPaddress.state,
WLPprofile.firstName,
WLPprofile.lastName,
WLPprofile.organization,
WLPcountry.languageName
FROM WLPbib
LEFT JOIN WLPprofile ON WLPprofile.profileID = WLPbib.profileID
LEFT JOIN WLPaddress ON WLPaddress.publisherID = WLPbib.publisherID
LEFT JOIN WLPcountry ON WLPcountry.countryID = WLPaddress.countryID");
I now get results in triplicate. ie. I'm getting three copies of the same title, firstName, organization, etc....
I somehow suspected that this should be the result with LEFT JOIN, but I'm not sure how to return a query without duplication.
This is far better than what I had this morning (which was no response from the server).
Thanks. I'm new to joining tables...
Mike
--
Mike Gifford, OpenConcept Consulting, http://openconcept.ca
Offering everything your organization needs for an effective web site.
Abolish Nuclear Weapons Now!: http://pgs.ca/petition/
It is a miracle that curiosity survives formal education. - A Einstein