+ Start a Discussion
Rakesh KumarRakesh Kumar 

error : semi join sub selects can only query id fields, cannot use : 'Line_nov_usr__c '

Hi

 

I am getting an error like " semi join sub selects can only query id fields, cannot use : 'Line_nov_usr__c ' ".

I dont know why its giving such type of error.

Is there any miss or need to do apend something here?

 

code will be:

 

SELECT Line_nov__c,Feild_2_nov__c, Field_3_nov__c, Field_4_nov__c FROM Patient_Survey_ONC_nov__c where Line_nov__c In (Select Line_nov_usr__c from user where id='005U0000000onrNIAQ') and Line_nov__c !=null

 

Any clue or idea.

 

Thanks

Rakesh