greg.scharlemann@gmail.com wrote:
> 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.

I got it. My tables were not correctly aligned. I had deleted a Person
but did not remove the PersonID from the PersonLocale table.