This message has been edited. Last edited by: <Allen Richardson>,quote:Originally posted by Allen Richardson:SET ASNAMES=ON SQL MYSQL SELECT T1.idRoute AS 'ID', T1.Name AS 'ROUTENAME', T2.Description AS 'DESCRIPTION', FROM ROUTE_TAB T1 LEFT OUTER JOIN CHANNEL T2 ON T1.idRoute = T2.idRoute END -RUN TABLE FILE SQLOUT PRINT * BY ID ON TABLE HOLD FORMAT FOCUS INDEX 'ID' END
Getting the error that it not recognize the ID.
I'm sure whether the SET ASNAMES affect the SQL query.