Query of Queries syntax issue

[T McDizzle]

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.

[Dan Bracuk]

You mean to say that something like this is not supported in Q of Q?

select some fields from query1
where name not in (#QuotedValueList(query2.rating)#)

[T McDizzle]

I have resolved the issue finally. Thank you very much.