Sqlite : duplicate column name:

Viewed 387

While selecting some data from a sqlite db using the cli:

SELECT * FROM 'myData' WHERE (StateCode != 'NULL' AND IHV != 'NULL');

I got:

[1:36:30 PM][vscode-sqlite][ERROR] duplicate column name: LHV

checking the schema:

sqlite> .open test.db
sqlite> .schema myData

CREATE TABLE IF NOT EXISTS "myData" (id integer primary key autoincrement,  PropertyId text UNIQUE, Year text, PropertyType text, PropertyTypeCode text, InCart text, Status text, HideValues text, MapAddress text, AppraisedValueDisplay text, DetailUrl text, PaymentProcessor text, StateCode text, IHV text, LHV text );
sqlite> 

What's wrong here?

0 Answers
Related