Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

tables assitance


Recommended Posts

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


This topic is now archived and is closed to further replies.

  • Create New...