delete mit join

[omata]

Hallo hoika,

was spricht gegen folgende Variante...

SQL-Code:

DELETE FROM DataFoxInput_Details1
WHERE DataFoxInputId IN (SELECT id
                         FROM DataFoxInputId
                         WHERE TheDate = :CheckDate)
  AND Flag IS NULL
  AND CardNo IS NULL

oder auch...

SQL-Code:

DELETE FROM DataFoxInput_Details1
WHERE EXISTS (SELECT *
              FROM DataFoxInputId
              WHERE TheDate = :CheckDate
                AND id = DataFoxInputId)
  AND Flag IS NULL
  AND CardNo IS NULL

Gruss
Thorsten