lcRawData = addbs(fileloc) + "surveys/RawData2005" rawdata = 'RawData2005' lcPermID = '20011' lcJoincondition = 'Companyinfo.company = RawData2005.company' lcON=lcRawData + '.company' SELECT Companyinfo.*, (lcRawData + '.*'); FROM ; COMPANYINFO ; INNER JOIN (lcRAWDATA) ; on Companyinfo.company = &lcOndata ; WHERE Companyinfo.permid = ( "20011" )>The following code sequence will work fine
>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" ) >>