Thanks Sergey,
thought I was going crazy!
>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,