Does anyone know if there is there a way to express something like the following in my relations/predicates?
select * from tblLetter
JOIN tblUserLetter ON tblLetter.LetterID = tblUserLetter.LetterID
LEFT JOIN tblCategoryLetter ON (tblLetter.LetterID = tblCategoryLetter.LetterID AND tblCategoryLetter.CategoryID = 7)
WHERE tblUserLetter.UserID = 3
AND tblCategoryLetter.CategoryID is null
The part that I am trying to figure out how to implement is the
_**LEFT JOIN tblCategoryLetter ON (tblLetter.LetterID = tblCategoryLetter.LetterID AND tblCategoryLetter.CategoryID = 7)**_
I am trying to pull Letters for User that are not already in a certain category...
I'm wondering if there is some other way that I can just do this in the predicateexpression itself, but can't really figure it out.
Any help would be greatly appreciated.
Best regards,
Hal