Figured it out! I had set the column Deleted to "CHAR" but all the fields without 'X' were null. If I replaced null with a valid character it worked. Thanks for your time. Scott ValleryEcclesiastes 4:9-10
On Thursday, January 31, 2019, 12:46:34 PM EST, Scott <scottvall...@yahoo.com> wrote: I can return results successfully from the t.Topic and n.Deleted columns separately, but when I try to use AND I receive no results. I'm not sure what I may be doing wrong. This is my first exhaustive work with a database project, so I've had to learn some syntax along the way, but has me stumped. SELECT n.NoteID, s.SourceType, s.Title, c.Summary FROM Comment as c LEFT JOIN Notes as n ON n.CommentID = c.CommentID LEFT JOIN Source as s ON n.SourceID = s.SourceID LEFT JOIN Topic as t ON n.TopicID = t.TopicID WHERE (t.Topic = 'Manuscript Copies') AND (n.Deleted <> 'X') I've tried and even with INNER JOIN: (WHERE t.Topic = 'Manuscript Copies') AND n.Deleted <> 'X')WHERE (t.Topic = 'Manuscript Copies') AND (n.Deleted <> 'X') WHERE t.Topic = 'Manuscript Copies' AND n.Deleted <> 'X' Thanks, Scott ValleryEcclesiastes 4:9-10 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users