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
<[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
