find matched query

[wardy]

Hello all,
could annyone help me with this?
i have a database with two tables in it, table x and table y,, i would like to find those records in table x that are not in table y, both tables contain the same ACTID key,, i have used the find un-matched query,, i'm just looking for a finid matched query if one exists???
many thanks

 

[Dennisk]

to view those records in x and not in y set the criteria for the linking field in y to is not null.

or the converse is null