Delete records based on multiple JOINs

Dbase3tate
Registered Posts: 7 ✭✭
Newbie here. Trying to convert a SQL from HIVE that pulls records partly based on several JOIN conditions but limits those record based on other JOIN conditions. In SQL it is a "WHERE NOT EXISTS" condition.
The following is the code -
SELECT x FROM y, z
Multiple left joins…
(and)
WHERE NOT EXISTS
(
SELECT 1
FROM
PA_QUAL_CPNT QC1
WHERE
QC1.QUAL_ID = QC.QUAL_ID
AND QC1.CPNT_ID = QC.CPNT_ID
AND QC1.REV_DTE = QC.REV_DTE
AND QC1.CPNT_TYP_ID = QC.CPNT_TYP_ID
)
Any suggestions?
Operating system used: Windows
Operating system used: Windows
Tagged:
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,329 Neuron
Use a SQL recipe and you can copy / paste your SQL.