RE: [PHP] Duplication Results When LEFT JOIN is Used Between MultipleTables

2001-07-11 Thread Chadwick, Russell
[PHP] 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, >> WLPbi

Re: [PHP] Duplication Results When LEFT JOIN is Used Between MultipleTables

2001-07-11 Thread Mike Gifford
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,

Re: [PHP] Duplication Results When LEFT JOIN is Used Between MultipleTables

2001-07-11 Thread Kamil Choma
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, >