Would like to explian further with below example i am using MS SQL Server
I have 2 Table TableA and TableB
TableA
TableB
Now i want to select column SupplierID from TableB only where TableA_ID = 1 and 2
The result that i want to be displayed is SupplierID = 4
The problem that i am facing is if i use WHERE IN (1,2) condition other SupplierID are also displayed, can anyone help me how shall i put Query so i get desired results.
Please let me know if above was not clear.