[Solved] SELECT....NOT IN ()
Posted: Wed Jan 16, 2019 3:27 am
Hello All,
Can someone guide me in the right direction with the code below?
I need to have 2 criteria verified at the same time.
Thanks in advance,
Dream
Can someone guide me in the right direction with the code below?
I need to have 2 criteria verified at the same time.
Code: Select all
SELECT
"vQuery8"."CompanyID",
"vQuery8"."CertificateQualificationID"
FROM
"vQuery8"
WHERE
"CompanyID" AND
"CertificateQualificationID"
NOT IN
(
SELECT
*
FROM
"vQuery9"
)
Dream