Hello Jason, Your second example ends with 0xA0 (a space with the high-bit set; sometimes used as a non-breaking space).
Graham Holden Wednesday, July 15, 2015, 8:53:20 PM, you wrote: > So yes, I was missing 'S's, but that is only because I've been hacking at the > tables to get something to change. > So the query you gave me works, however, when I put it all on the same line, > it is identical to my query which does not. To prove this, I updated the file > on github with a query table. > Just select from it, and paste it into the shell: sqlite>> select * from queries; > 1|select * from PatientTreatmentNotes ptn join PatientTreatmentNotesSteps pts > ON pts.TreatmentNoteID = ptn.TreatmentNoteID ;|works > 2|select * from PatientTreatmentNotes ptn join PatientTreatmentNotesSteps pts > ON pts.TreatmentNoteID = ptn.TreatmentNoteID?;|error sqlite>> select * from PatientTreatmentNotes ptn join PatientTreatmentNotesSteps pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID ; sqlite>> select * from PatientTreatmentNotes ptn join PatientTreatmentNotesSteps pts ON pts.TreatmentNoteID = ptn.TreatmentNoteID?; > Error: no such column: ptn.TreatmentNoteID
