Question
Query of Queries syntax issue
I have query 1 which has a list of names and query 2 which
has ratings for the names. Every rating from query 2 has a name in
query 1, but not every name from query 1 has a rating in query 2. I
need to make a query of queries that will result in a list of the
suppliers from query 1 that do not have a rating in query 2. I
tried to do a left outer join, but syntax wouldnt allow it. I also
tried to use "not in", but that is not allowed in a query of a
query either. I just need to find a way to get the ones that do
have a rating and the ones that dont in a query with their
respective names in either one query or two. Any help would be
appreciated. Thanks.
AdChoices