greg.scharlem...@gmail.com wrote:
> strawberry wrote:
> >
> > SELECT P.PersonID FROM PersonLocale PL
> > LEFT JOIN Person P ON P.PersonID = PL.PersonID
> > WHERE State = 'NC'
> > ORDER BY LastName,FirstName
>
> Thanks, but the first two records that I get a NULL and I none of the
> columns that I'm quering on have a NULL value. Any idea why?

I think it's showing an AgentID that is all zeros (00000000) as NULL.
Not sure why it's listing it twice though.