Re: Simple Delete Gets Complex (What if delete becomes modify???)

Mark D. Stock wrote: : Or do you need to do a full correlated subquery: : : DELETE FROM Table_A : WHERE Table_A.PK IN : (SELECT TA.PK : FROM Table_A TA, Table_B TB : WHERE TA.PK = TB.FK : AND TA.PK = Table_A.PK : AND ... : ); Why would you need a correlated subquery like this? It seems to me that Table_A.* = TA.* because of the condition TA.PK = Table_A.PK. Am I missing something? --Kevin