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

2001-07-11 Thread Maxim Maletsky
not to give you the solution, but there's something you can simplify in your query: USING(field) mysql_query(SELECT WLPbib.bibID, WLPbib.title, WLPbib.publisher, WLPbib.publicationDate, WLPaddress.city, WLPaddress.state,

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

2001-07-11 Thread Mike Gifford
Hi Max, Maxim Maletsky wrote: not to give you the solution, but there's something you can simplify in your query: USING(field) I like the idea of using USING... however I've run into some problems. mysql_query(SELECT WLPbib.bibID, WLPbib.title,