♥yesudo Posted February 20, 2004 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.
♥yesudo Posted February 20, 2004 Author Posted February 20, 2004 This is still stumping me. Your online success is Paramount.
♥yesudo Posted February 22, 2004 Author 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.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.