I have a database with 3 tables tblSources, tblSource2Keyword, and tblKeywords. I'm trying to query the server to select all of the sources that have tblKeywords.keyword1 AND tblkeyword.keyword2, using the following statement.
SELECT tblSources.SourceID FROM tblSources
LEFT JOIN tblSource2Keyword ON tblSource2Keyword.SourceID = tblSources.SourceID
LEFT JOIN tblKeywords ON tblSource2Keyword.KeywordID = tblKeywords.KeywordID
WHERE tblKeywords.keyword LIKE 'keyword' AND tblKeywords.keyword LIKE 'keyword2'
But I keep getting an empty result set and I have verified that the source is associated with the 2 keywords. What is the correct syntax to achieve this?
Let me know if you need more information.