SQLCE Subquery for smart device application
<p>I crate two tables name abc1 and xyz.
abc1 having column id, name and add. where xyz table having id, mob.</p>

<p>select name from abc1 where id =(select id from xyz)</p>

<p>getting an error There was an error parsing the query. [ Token line number = 1,Token line offset = 34,Token in error = select ]</p>

<p>please help me on this query.</p>
