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" )
but this one will not
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" )
The construct fails with the indirect pointer in the 'ON' statement. I've tried every combination of (), "", and & that I can think of but can't seem to make it work. The query will run without error but it doesn't find any records. Any help will be greatly appreciated.