I have two table named A and B in both table 6 and 10 records are inserted respectively, in both table one field is common. How can we compare the records f both table using that common field and found that records which are not in the table A.

abhisingh
Kilo Contributor

I have two table named   A and B in both table 6 and 10 records are inserted respectively, in both table one field is common. How can we compare the records of both table using that common field and found that records which are not in the table A.

10 REPLIES 10

Thanx   for your effort, i got this. It was really helpful.