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 for Windows 10