Re: How Do I do This Update

From: Bryan Dollery <bryan_at_bryan.prestel.co.uk>
Date: 1997/06/30
Message-ID: <33B7BBB6.385343A@bryan.prestel.co.uk>#1/1

This is a multi-part message in MIME format.

--------------B2890B32C8C58BDAF6F43A0D
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

update A

set        field1 = val1,
            field2 = val2

where part_no in
(

    select part_no
    from B
)

Bryan

---

Brett Moran wrote:

> I have table A with 5000+ rows and table B with 2200+ rows. They are
> keyed on a part number. Table A includes all part numbers, table B
> only
> those that need to be updated. I've tried using an update with an
> embedded select using several combinations and approaches. They all
> update every row of table A instead of the rows that have a match in
> table
> B. Can someone help. Please email. Thanks.

--------------B2890B32C8C58BDAF6F43A0D
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Bryan Dollery
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Bryan Dollery
n:              Dollery;Bryan
org:            ByteSmart Systems Ltd.
email;internet: bryan_at_bryan.prestel.co.uk
note:           Consultant Software Engineer

=0A=
B.Sc. (Hons). Software Engineering
=0A=
MD - ByteSmart Systems Ltd.
x-mozilla-cpt: ;0
x-mozilla-html: TRUE
end: vcard

--------------B2890B32C8C58BDAF6F43A0D-- Received on Mon Jun 30 1997 - 00:00:00 CDT