EXTRACTING UNRELATED RECORDS

[Haas]

I have two tables imported from excel I related the records, but in one table
i have an orphaned records that doesn't have a related records in the other
table, I made a query and its working fine giving around 1850 related
records, but in one table i have more then 1000 that don't have related
records in the other table, Is there a way that i can extract from this
table, these orphaned records.

Now I am checking the table in a datasheet view and then clicking + to
expand to view if there is related record in the other table.

Is there easy way that i can get these records,

Your assistance is appreciated.

Thanks men.

 

[Sylvain Lafontaine]

Using the Exists statement or a LEFT JOIN will give you what you want; for
example:

Select A.* from A Left Join B on A.Id = B.Id where B.Id is Null

 

[Haas]

Thank you very much Mr. Lafontaine, its indeed a great assistance, very
helpful man, thanks once again.