[sqlite] Error: no such column: When column exists!

[Simon Slavin]

On 15 Jul 2015, at 3:09pm, Jason H <jhihn at gmx.com> wrote:

> 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,
>  ...
> );

Please try

select * from PatientTreatmentNote join PatientTreatmentNoteStep ON 
PatientTreatmentNoteStep.TreatmentNoteID = PatientTreatmentNote.TreatmentNoteID;

and tell us what happens.

Simon.