I am at a total loss! I cannot figure out the correct syntax for a query that is trying to find unmatched records.
I have the following tables:
The query will have a particular TTechID that it needs to find any WebsiteID's that are not in the tblProductPrice.SiteID for that specific TTechID.
I've tried the following sql
WHERE NOT EXISTS (SELECT SiteID FROM tblProductPrice WHERE tblProductPrice.SiteID = tblWebsite.WebsiteID)
FROM tblWebsite LEFT JOIN tblProductPrice ON tblWebsite.WebsiteID = tblProductPrice.SiteID
WHERE (((tblProductPrice.SiteID) Is Null));
Neither of these work correctly specifically because they don't have any reference to the TTechID in question.
Please help me add whatever conditional statement is needed to refine the query search to the specific TTechID in question.