Duplication Results When LEFT JOIN is Used Between Multiple Tables

From: 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

« previous php.general (#57406) next »