i have three tables that all have the correct data inserted.
Code: Select all
SELECT * FROM host_editprop2014, host_payments2014, plus_signup2014 WHERE plus_signup2014.userid = host_payments2014.payment_userid AND host_editprop2014.prop_id = plus_signup2014.prop_id AND plus_signup2014.propFull = host_editprop2014.prop_idi know the data within the tables is correct but nothing is being returned
Code: Select all
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0213 seconds.)if i remove
Code: Select all
AND plus_signup2014.propFull = host_editprop2014.prop_idthe same applies for
Code: Select all
AND host_editprop2014.prop_id = plus_signup2014.prop_idCode: Select all
plus_signup2014.userid = host_payments2014.payment_userid ANDbut if i run this query on its own i get results
am i missing something?
thanks