morpheusdreams
MIS
Have a query that i want to build but am not sure of the terminology to search for so I will attempt to describe the problem:
I have two tables
tbl_Names
Name
Andrew
Simon
Barry
tbl_Records
Name|Product
Andrew|Apple
Andrew|Banana
Simon|Pinecone
Barry|Apple
Simon|Apple
Dave| Apple
Dave| Sunflower
Ted| Coffee
I need a query that will return only distinct values from "tbl_Records" column "Name" which do not appear in "tbl_Names".
So if you ran it on the above you would come out with:
qry_Names
Distinct_Name
Dave
Ted
Hope that made sense and apologies if this is on here already but like i said above, i have no idea what terminology i want to search for.
Thank you in advance,
MD
I have two tables
tbl_Names
Name
Andrew
Simon
Barry
tbl_Records
Name|Product
Andrew|Apple
Andrew|Banana
Simon|Pinecone
Barry|Apple
Simon|Apple
Dave| Apple
Dave| Sunflower
Ted| Coffee
I need a query that will return only distinct values from "tbl_Records" column "Name" which do not appear in "tbl_Names".
So if you ran it on the above you would come out with:
qry_Names
Distinct_Name
Dave
Ted
Hope that made sense and apologies if this is on here already but like i said above, i have no idea what terminology i want to search for.
Thank you in advance,
MD