Hitachi

Hitachi Advanced Database Messages


KFAA30203-E

Column "aa....aa" cannot be determined in the SQL statement. (query number = bb....bb) (M+J+O)

The specified column aa....aa cannot be identified as the name of a column in a specific table. Two or more tables specified in a query have the same column name. <SQLSTATE: 42744>

aa....aa:

Column name that belongs to two or more tables specified in the query

bb....bb: Position number of the query that specified aa....aa

For details about query position numbers, see 1.5 Query position numbers.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Qualify the column name with a table name so that the column name can be identified as belonging to a specific table.