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?
The American Republic will endure, until politicians realize they can bribe the people with their own money.
- Alexis de Tocqueville
No man’s life, liberty, or property is safe while the legislature is in session.
– Mark Twain (1866)
