I am trying to get result using Joined result from two tables
first I tried with some static value which worked.
select tblImportedContacts.*,tbladdress.* from tblImportedContacts,tbladdress where (shouldShowProfile = 'true' OR isUsingDYRCT ='false') and tblImportedContacts.id='140603902368000'
then I tried without static value in Where clause, Which didn't worked
select tblImportedContacts.*,tbladdress.* from tblImportedContacts,tbladdress where (shouldShowProfile = 'true' OR isUsingDYRCT ='false') and tblImportedContacts.id= tblAddress.user_id
I want to get the result from two tables tblImportedContacts and tblAddress if id field of tblImportedContacts has the same string value in user_id of tbleAddress.
both the Fields are of type Text
Can anyone help me in finding the mistake from second Query?
Aucun commentaire:
Enregistrer un commentaire