Delete records based on multiple JOINs

Dbase3tate

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

Turribeach

Use a SQL recipe and you can copy / paste your SQL.