On 15 Jul 2015, at 8:53pm, Jason H <jhihn at gmx.com> wrote: > sqlite> select * from PatientTreatmentNotes ptn join > PatientTreatmentNotesSteps pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID ; > Error: no such column: ptn.TreatmentNoteID
I downloaded your database file and copied straight from the above. They all work fine for me, resulting in no rows and no errors. Whatever you think you're typing, you're not. To test it type it out by hand rather than cutting and pasting. Simon.
