>lcRawData = addbs(fileloc) + "surveys/RawData2005" >rawdata = 'RawData2005' >lcPermID = '20011' >lcJoincondition = 'Companyinfo.company = RawData2005.company' > >SELECT Companyinfo.*, (lcRawData + '.*'); > FROM ; > COMPANYINFO ; > INNER JOIN (lcRAWDATA) ; > on Companyinfo.company = RawData2005.company ; > WHERE Companyinfo.permid = ( "20011" ) >>
>lcRawData = addbs(fileloc) + "surveys/RawData2005" >rawdata = 'RawData2005' >lcPermID = '20011' >lcJoincondition = 'Companyinfo.company = RawData2005.company' > >SELECT Companyinfo.*, (lcRawData + '.*'); > FROM ; > COMPANYINFO ; > INNER JOIN (lcRAWDATA) ; > on Companyinfo.company = (lcRawData + '.company') ; > WHERE Companyinfo.permid = ( "20011" ) >>
SELECT * ; FROM ; COMPANYINFO t1 ; INNER JOIN (m.lcRAWDATA) t2 ; on t1.company = t2.company ; WHERE t1.permid = ( "20011" )Cetin