> delete from A where ID in
> (select B.A_ID from A A2 RIGHT OUTER JOIN B
> ON B.A_ID=A2.ID where A2.ID IS NULL)
> the syntax is "off the top of my head" - (handing should be right? - "where
> A2.ID IS NULL" may be dead-in-the-water).
The ORACLE would be something like
DELETE FROM A
WHERE
ID IN (
SELECT
A.ID
FROM
A,B
WHERE
A.ID=B.ID (+) AND B.ID IS NULL
);
To delete elements from A that are not in B since the outer join adds null rows
to B and returns a true for A.ID=B.ID.
In the above syntax this would appear to be
DELETE FROM A
WHERE ID IN (
SELECT A.ID FROM A RIGHT OUTER JOIN B ON A.ID=B.ID
WHERE B.ID IS NULL
);
Correct?
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
