I've searched forums and the net for too many hours and can't find the answer to this.
This is one thing I've tried that seems like it should work.
select pkey, name
from tbl_1
where not exists (select * from tbl_2 where lpkey = pkey)
lpkey from tbl_2 is a foreign key to pkey from tbl_1
I just want to list the names of those whose key from tbl_1 are not currently in tbl_2.
Any ideas?
This should be easy but it just escapes me.
Thanks for the help!
____________________________
JustKIDn
____________________________
Families can be together forever...
This is one thing I've tried that seems like it should work.
select pkey, name
from tbl_1
where not exists (select * from tbl_2 where lpkey = pkey)
lpkey from tbl_2 is a foreign key to pkey from tbl_1
I just want to list the names of those whose key from tbl_1 are not currently in tbl_2.
Any ideas?
This should be easy but it just escapes me.
Thanks for the help!
____________________________
JustKIDn
____________________________
Families can be together forever...