Whenever I try a multi-table join on a field I get a no such column error. sqlite> select * from PatientTreatmentNote ptn join PatientTreatmentNoteStep pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID?; Error: no such column: ptn.TreatmentNoteID sqlite> .schema PatientTreatmentNote CREATE TABLE PatientTreatmentNote( TreatmentNoteID, ... );
The database is UTF-8. I have written a python script to print the characters of the field name as to eliminate the possibility of any non-US ASCII characters in the field name. Can anyone tell me why it can't find the column? Many thanks in advance.