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,

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 Chadwick, Russell
] 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