Mike Gifford wrote: > 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 > -- Maybe SLECT DISTINCT ... could help you. Kamil -- ---------------------------------- [EMAIL PROTECTED] ---------------------------------- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]