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.