SQL Codes › SQL Return Codes -1 through -999 › -162 - CANNOT INSERT AND SELECT ON THE SAME TABLE

-162 - CANNOT INSERT AND SELECT ON THE SAME TABLE

Explanation

You have specified the same table or view name in both an INSERT INTO and a FROM clause.

The SQLSTATE that equates to this SQL return code is 42902.

User Response

Change the table name or view name in either the INSERT INTO or FROM clause.