See Re: Does Properties work? Message #838311

>
>I'm running a query like this:
>
>

>SELECT [DateArrive]
>      ,[StLucia_National].[dbo].[Carriers].[car_pk]
>      ,[Flight_No]
>      ,[BirthDate]
>  FROM [StLuciaOld].[dbo].[EdCard]
>	left outer join [StLucia_National].[dbo].[Carriers] on [Carrier] = [StLucia_National].[dbo].[Carriers].[car_code]
>

>
>This returns 1,631,147 rows.
>
>However, the Properties of [StLuciaOld].[dbo].[EdCard] says there are 1,630,724 records.
>
>Can anyone please explain to me why the difference? I was expecting that my query should return as many rows as there are in the [StLuciaOld].[dbo].[EdCard] table.
>
>Thanks,