How to delete records that column have same value in another table?

Bie1234
New Contributor III

‎02-15-2023 02:18 AM 

delete from DWH.SALES_FACT
 
where SALES_DATE in (select SALES_DATE from STG.SALES_FACT_SRC)
    AND STORE_ID in (select STORE_ID from STG.SALES_FACT_SRC)

output : Error in SQL statement: DeltaAnalysisException: Nested subquery is not supported in the DELETE condition.

Is there any way to avoid this error? ' cause I'm scared the performance when the DWH.SALES_FACT more volume in the future when create temp table.

Labels: