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, > WLPb

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, WLP