var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Exclude records from query results of tableA when records exist in tableB
I am trying to write a query where I exclude records from my query results from TableA when records with two key fields exist in tableB.
I can get it to exclude from the return results when I am trying to exclude based on just one keyfield but I can't get it to work when I want to use two fields as the exclusion criterion.
Here is what I am using so far:
WHERE (((TableA.PK1) Not In (select PK1 from TableB))
I have tried just adding a second WHERE or an AND but don't seem to be getting anywhere...except maybe greyer!
ON TableB.pk1 = TableA.pk1
AND TableB.pk2 = TableA.pk2
WHERE TableB.pk1 IS NULL
That did it
Awesome! That did it! Thanks for the help. I had been scratching my head all day!