1.15.5 If message KFAA30203-E is displayed
In a retrieval that spans two tables, if both tables contain a column with the same name, the column name must be specified in the format "table-name"."column-name" in order to identify which table the column is in.
Example:
SELECT "USERID","NAME","PUR-CODE","PUR-DATE" FROM "SALESLIST","USERSLIST" WHERE "PUR-DATE">=DATE'2011-09-06' AND "SALESLIST"."USERID"="USERSLIST"."USERID" KFAA30203-E Column "USERID" cannot be determined in the SQL statement.(query number = 1)
In this example, the underlined portion of the statement is incorrect. Specify it using the format "table-name"."USERID" (for example, "SALESLIST"."USERID").