Query will execute when inner query have issue

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<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10