SQLite Forum

SQLite says “no such column: rowid”
Login
I want to add a JOIN into an existing request but I get an error as result and I dont understand why. Someone can tell me what I'm doing wrong?

I send the following request:
SELECT rowid, idSource, idFabric, codeItem, ,notes FROM TableSourcesItems
 INNER JOIN TableSources ON TableSourcesItems.idSource = TableSources.rowid
WHERE rowid = <value from variable>;

And I get the result:

[SQLITE_ERROR] SQL error or missing database (no such column: rowid)

I have no error if I remove the 'INNER JOIN ... ON ...' Part

Thank you for your help.