G
Guest
Does anyone know how I could find all the values in one table that are not in another?
I have a table named login; the fields are ID, first_name, last_name...
I have another table named tb; the fields are ID, tb_ID, and last_tbdate.
Here's the relationship: ID.login ----------> tb_ID.tb
The ID fields in both tables are unique key autonumber.
EX. login:
ID first_name last_name
1 jeremy scott
2 john doe
3 jane michaels
4 brian peterson
5 bill gates
EX. tb
ID tb_ID last_tbdate
1 1 09/02/2003
2 1 09/01/2002
3 3 09/05/2004
4 5 09/10/2003
5 5 09/10/2002
The answer should be:
first_name last_name
john doe
brian peterson
because neither john nor brian have any records in the tb table.
i can't seem to get this to work and any halp would be much appreciated thanks
I have a table named login; the fields are ID, first_name, last_name...
I have another table named tb; the fields are ID, tb_ID, and last_tbdate.
Here's the relationship: ID.login ----------> tb_ID.tb
The ID fields in both tables are unique key autonumber.
EX. login:
ID first_name last_name
1 jeremy scott
2 john doe
3 jane michaels
4 brian peterson
5 bill gates
EX. tb
ID tb_ID last_tbdate
1 1 09/02/2003
2 1 09/01/2002
3 3 09/05/2004
4 5 09/10/2003
5 5 09/10/2002
The answer should be:
first_name last_name
john doe
brian peterson
because neither john nor brian have any records in the tb table.
i can't seem to get this to work and any halp would be much appreciated thanks