Re: Delete with Multiple Field Select

[Charles Wilt <charles.wilt@xxxxxxxxx>]

two ways

Delete from filea where fld1 CONCAT fld2 in (select fld3 CONCAT fld4 from fileb)

Delete from filea A where exists (select * from fileb B where a.fld1 =
b.fld3 and A.fld2 - B.fld4)

HTH,
Charles


On Fri, Aug 17, 2012 at 3:13 PM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:
> Bah! Friday afternoon...can't think...why can't I do this?
>
> Delete from filea where fld1, fld2 in (select fld3, fld4 from fileb)
>
> and how would I do it?
>
> Thanks...
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.