How to filter data in two tables

Question

hi I have two tables TableA and TableB of data with common coloumns name fkcolumnb and pkcoloumna in two tables

how to retrive data which are not present in TableA?

 

 

thanks in advance

---

satwick

Answer 1

Select * From TableB Where Not Exists (Select 1 From TableA Where TableA.PKColumnA = TableB.FKColumnB)

---

Best Wishes, Arbi --- MCC 2011; Please vote if you find this posting was helpful or Mark it as answered.

Answer 2

Hi, try please :

Select

B.* From TableB B

left

join TableA A on A.PKColumnA = B.FKColumnB

Where A.PKColumnA is NULL

 

 

---

Best regards