Greetings,
We tried query in a following manner.
SELECT * FROM A where A.id IN (SELECT B.id from B);
In the above query Table B does not have id. But this query return all A table records
Note : If we run inner query alone, It throws error like “Field is not found”
Sent from Mail for Windows 10
