searching table

[pwgeary]

Never mind i found a solution, it is not the best but it works

i have two tables t1 and t2
t1 has one field id
t2 has a bunch of fields but has id as well

t1 is alist of all possible id's that can be displayed
so is an id that is in t2 is not in t1 then i want to delete the record from t2

T1 T2

12 12
24 22
31 24
43 41
43

So it is ok to have id's in T1 that are not on T2 but T2 can only have Id's that are also on T1. So records with the id 22 and 41 from t2 would be deleted. If anyone has anythoughts they would be appreciated.
Thanks



Never mind I found a solution. It is not the best but it will work.

[Bullschmidt]

I didn't understand why a question would start with "Never mind I found a solution..." until I looked and saw the following at the bottom:

"Last edited by pwgeary on..."

:eek2: