On 7/15/15, Jason H <jhihn at gmx.com> wrote: > Since attachments are not supported, > https://github.com/jhihn/files/blob/master/no_such_column.sqlite3 >
The table names were both misspelled in your original query. After I fixed that, everything seems to work. I tested with 3.7.8, 3.7.17, 3.8.0, 3.8.7, and trunk. select * from PatientTreatmentNotes ptn join PatientTreatmentNotesSteps pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID ; -- D. Richard Hipp drh at sqlite.org