There is a 1 to many relationship from companyinfo to rawdata. There were two records in companyinfo that were not unique thereby creating the problem. When the 2 false records were eliminated, the problem was solved.

Thanks for your interest.

>How many does lcCompanyInfo that matches RawData?
>
>>Given the following code sequence
>>

>>lnYear = 2005
>>lcRawData = fileloc + 'surveys\RawData' + transform(lnYear)
>>lcCompanyInfo = fileloc + 'surveys\companyinfo'
>>
>>select * ;
>>	from (lcRawData) rd, ;
>>	(lcCompanyInfo) ci ;
>>	where rd.permid = ci.permid and ci.yearproduced = lnYear
>>
>>

>>The RawData table contains 98274 records. If the WHERE clause of the select creates an inner join (does it not?) how can the result set contain 98511 records?