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 = lnYearThe 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?