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").

To Page Top