Description

The following is an example.

Table Definition:

Based on the example, the following queries can cause the error: Column 'xxxx' cannot be resolved:

SELECT id1 FROM tbl;
Column 'id1' cannot be resolved

or

SELECT id FROM tbl WHERE id="123" ;
Column '123' cannot be resolved

Cause

Column 'id1' does not exist (the column specified in the SQL query is incorrect).

or

Double quotations are used to contain the string in the WHERE clause. Double quotations can be used only to specify the column name.

Resolution

Use correct column name in SQL query.

SELECT id FROM tbl;

or

Use single quotations around strings values.

Do not use any quotations when specifying a number.

SELECT id FROM tbl WHERE id=123 ;