NOT IN problem with GUIDs

  • Thread starter Thread starter Craig Buchanan
  • Start date Start date
C

Craig Buchanan

I'm having a problem with a query that uses a subselect on a GUID field.
The query doesn't return the correct number of row. There are 10 total
records, the subquery (works correctly by itself) returns 1 record. The
whole query should return 9 rows. What am I missing? Is this a GUID issue?

PARAMETERS GroupId Guid;
SELECT Person.Id, [LastName] & ", " & [FirstName] AS FileAs
FROM Person
WHERE Person.Id Not In (PersonId FROM GroupPerson WHERE GroupId = [GroupId])

Thanks.

Craig
 
Try

WHERE Person.Id Not In (SELECT PersonId FROM GroupPerson WHERE GroupId =
[GroupId])
 
Back
Top