[AccessD] A2000: DELETE query with JOIN

Jeff,

Aye, there's the rub. The Primary Key is this series of four CAS
fields. There's no single-field primary key. Thanks for the try.

Steve Erbach


On Mon, 14 Feb 2005 12:08:01 -0600, jeffrey.demulling at usbank.com
<jeffrey.demulling at usbank.com> wrote:
> Have not tried this but it might work.
> 
> DELETE T1.*
> FROM
> (SELECT
> T1.PrimaryKey
> FROM
> T1
> JOIN T2
> ON
> (T1.CAS4 = T2.CAS4)
> AND
> (T1.CAS3 = T2.CAS3)
> AND
> (T1.CAS2 = T2.CAS2)
> AND
> (T1.CAS1 = T2.CAS1) AS tempQuery)
> WHERE
> tempQuery.PrimaryKey = T1.PrimaryKey
> 
> Jeffrey F. Demulling
> Project Manager
> U.S. Bank Corporate Trust Services
> 60 Livingston Avenue
> EP-MN-WS3C