Simple query help please
Posted: Fri May 09, 2008 7:39 am
Two tables:
t1 = a list of ID's as int (1 - 100)
t2 = a list of ID's from t1 that get used during a year (2,4,6,8,9,20)
How do I get a list of ID's from t1 that are NOT also listed in t2? (the ones unused in t1)
I can easily get it when I want the ones used, but the unused is not working right.
Thanks
t1 = a list of ID's as int (1 - 100)
t2 = a list of ID's from t1 that get used during a year (2,4,6,8,9,20)
How do I get a list of ID's from t1 that are NOT also listed in t2? (the ones unused in t1)
I can easily get it when I want the ones used, but the unused is not working right.
Thanks