Re: Duplication Results When LEFT JOIN is Used Between MultipleTables

I added DISTINCT to the code (as per below): Kamil Choma wrote:

Mike Gifford wrote:

However, when I run this query: mysql_query("SELECT DISTINCT

        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....

Maybe SLECT DISTINCT ... could help you.

However not everything needs to be distinct. Just the bibID number actually. The results this produces though are no different than without it. 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