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" )