I am trying to update SIC Codes on the Account table with data provided by an outside source. I tried executing the following SQL statement in the SLX Administrator, but I get errors: Failed to parse SQL
SICCODE = L.SICCODE
from ACCOUNT A, LoadTable L
where A.ACCOUNTID = L.ACCOUNTID
This query works fine in SQL Server Query Analyzer, but I need the changes to be synched down to
the remote databases, so I need to run them in the SLX Admin. I am on SLX ver 7.5.2. Any suggestions?