Greywacke Posted April 12, 2010 Share Posted April 12, 2010 hi again,here is the sql string i am attempting to run: SELECT 5_suppliers.text_ContactFirstName, 5_suppliers.text_ContactSurname, 5_suppliers.text_SupplierName, 5_suppliers.`text_ContactE-mail`, 5_suppliers.bigint_CurrentBalance, 5_suppliers.bigint_ContactTel, 5_suppliers.text_SupplierAddress, 5_suppliers.bigint_SupplierID, 5_suppliers.text_GoogleMapsURL, 5_suppliers.text_VTigerData FROM 5_suppliers LEFT JOIN ( 4_servicesuppliers) ON ( 4_servicesuppliers.bigint_SupplierID = 5_suppliers.bigint_SupplierID) WHERE 5_suppliers.smallint_SupplierStatus = 0 AND 4_servicesuppliers.bigint_ServiceID = 1 AND 4_servicesuppliers.bigint_RegionID = 41; Link to comment Share on other sites More sharing options...
justsomeguy Posted April 13, 2010 Share Posted April 13, 2010 The syntax looks fine, so either the join condition or the where conditions are filtering everything out, although you're not selecting any fields from the joined table. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.