Jason, I downloaded your database and copied the SELECT from your original post.
sqlite> select * from PatientTreatmentNote ptn join PatientTreatmentNoteStep pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID ; Error: no such table: PatientTreatmentNote (note that this was because table name misspelled. Did not get a missing column error.) The SELECT needed three "s" characters added, one to the end of the name "PatientTreatmentNote" and two to make the second table name "PatientTreatmentNotesSteps" -- Then, running the modified SELECT, I get no error regarding missing a column. sqlite> select * from PatientTreatmentNotes ptn join PatientTreatmentNotesSteps pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID ; sqlite> (No data was returned, of course, as there were no rows in your tables.) Again, I was using sqlite3 commandline utility 3.8.10.2 on Win7. Are you saying you get a different result with your test db? Again, what version of sqlite3 and what OS are you using?
