lcRawData = addbs(fileloc) + "surveys/RawData2005"
rawdata = 'RawData2005'
lcPermID = '20011'
lcJoincondition = 'Companyinfo.company = RawData2005.company'

SELECT CI.*, RD.* ;
 FROM ;
     COMPANYINFO CI ;
    INNER JOIN (lcRAWDATA) RD ;
   on CI.company = RD.company ;
 WHERE  CI.permid = ( "20011" )