♥yesudo Posted February 20, 2004 Share Posted February 20, 2004 I have a table join here: $customers_query_raw = "select c.customers_id, c.source, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.source desc, c.customers_lastname, c.customers_firstname"; I actually want to add in a third table, TABLE3, which joins TABLE_CUSTOMERS at the field TABLE_CUSTOMERS.entry_source_id to TABLE3.sources_id. Can someone help me with the syntax please as I have been trying for a while but have not been able to crack it. Many thanx. Your online success is Paramount. Link to comment Share on other sites More sharing options...
♥yesudo Posted February 20, 2004 Author Share Posted February 20, 2004 This is still stumping me. Your online success is Paramount. Link to comment Share on other sites More sharing options...
♥yesudo Posted February 22, 2004 Author Share Posted February 22, 2004 sorry to bring this up again - I am still not able to get this to work - any ideas ? Your online success is Paramount. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.