[AccessD] A2000: DELETE query with JOIN

Steve Erbach erbachs at gmail.com
Mon Feb 14 13:20:51 CST 2005


Gustav,

Yes, it does. I've incorporated this kludge into my application successfully.

Steve Erbach


On Mon, 14 Feb 2005 19:16:16 +0100, Gustav Brock <Gustav at cactus.dk> wrote:
> Hi Steve
> 
> Oops, my fantasy stopped at the missing unique key ...
> However, the dirty trick as, as you mention, to concatenate the fields
> to a pseudo unique key:
> 
>   SELECT
>     CAS1 & "_" & CAS2 & "_" & CAS3 & "_" & CAS4 AS CAS
> 
> Not nice but it may work.
> 
> /gustav



More information about the AccessD mailing list