/* DIKKAT: delete isleminde FOREIGN KEY HER ZAMAN COK ONEMLIDIR. eger bagli oldugu child tablolardan birinde index eksiklgi varsa, bizi SURUNDURUR !!! */
DELETE FROM "Transactions" WHERE "Id" IN( SELECT tr."Id" FROM "hede" tr INNER JOIN "Transactions" H ON tr."Id"=H."Id" LIMIT 10) RETURNING *;
DELETE FROM "DBACHECKDB"."AddressIDLog" WHERE "AddressID" IN (SELECT D."AddressID" FROM "DBACHECKDB"."AddressIDLog" D LEFT JOIN "ERP"."Address" E ON D."AddressID"=E."ID" WHERE E."ID" IS NULL) RETURNING *;
-- Hemen yukaridaki sorgunun akabinde yazılır. Ve silinen degerleri dondurur. -- Boylece Neler silinmis gormus olursunuz. RETURNING *;
