mercredi 21 octobre 2015

Correlated Sqlite query is not working with string based Where condition

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