NOT IN problem with GUIDs

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Craig Buchanan (someone_at_microsoft.com)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 10:24:15 -0600

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

Relevant Pages

  • Re: Oracle Spatial SDO Aggregate Union fails with ORA-29913 ODCIAGGREGATEMERGE
    ... GEOMETRIE FROM DGDTW_TOPOGRAFIE; ... there is a administrative coupling on a guid. ... doesnt seem to make any difference(see query 3). ... 14 INNER JOIN DGDTW_OBJECTGUIDS GUIDS ...
    (comp.databases.oracle.misc)
  • Re: SQL Against MS Access
    ... >the specifying the Guid value, I get back 3 rows, all of them with the ... >from the query mentioned above), ... >FROM SkatingClubs sc, Skater s, SkatingLevels sl, Bracket b, Events e, ... > CompetativeEvents ce, CompetitionDescription cd, EventFinals ef ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: NOT IN problem with GUIDs
    ... WHERE Person.Id Not In (SELECT PersonId FROM GroupPerson WHERE GroupId = ... > I'm having a problem with a query that uses a subselect on a GUID field. ... Is this a GUID ...
    (microsoft.public.access.formscoding)
  • SQL Against MS Access
    ... supply a "Guid" value in the where clause. ... So now if I now change the query to specify that Guid number (returned ... FROM SkatingClubs sc, Skater s, SkatingLevels sl, Bracket b, Events e, ... CompetativeEvents ce, CompetitionDescription cd, EventFinals ef ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle Spatial SDO Aggregate Union fails with ORA-29913 ODCIAGGREGATEMERGE
    ... there is a administrative coupling on a guid. ... reason i want to union the polygons, so i have 1 geometry for 1 guid. ... Can somebody help me how i can get a query / view with the information ... 12 TOPO.GEOMETRIE AS GEOMETRIE ...
    (comp.databases.oracle.misc)