Re: Update one table based on data in another

Article View: borland.public.interbase.sql

Article #764

Back to borland.public.interbase.sql Previous Next

#764

From: Paul
Date: Wed, 27 Jun 2007 08:10

28 lines
2144 bytes

I guess what was confusing me was, that I could not see where to place
the comma's - clearly not looking closely enough.<g>

Thanks for the clarification.


On 26 Jun 2007 16:31:24 -0700, "Bill Todd" <no@no.com> wrote:

>Separate the field assignments with commas as shown below. This is
>shown in the description of the UPDATE statement in the IB Language
>Reference if you look closely.<g>
>
>UPDATE CUSTOMERS
>SET 
>NAME = (SELECT customers_imported.name
>FROM customers_imported
>WHERE customers.account_ref = customers_imported.account_ref),
>ADDRESS = (SELECT customers_imported.ADDRESS
>FROM customers_imported
>WHERE customers.account_ref = customers_imported.account_ref)
>WHERE EXISTS
>  ( SELECT 1
>    FROM customers_imported
>    WHERE customers.account_ref = customers_imported.account_ref);

OS : Windows XP Service Pack 2
Delphi : 2005 Service Pack 3 Installed
CPU : AMD 3500+

Technical Details

Message-ID: <v96483lgssas9gb83fh7dlrm4asohihh3p@4ax.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<bec083t4td4iqapnt5pu2sm66tp172oudu@4ax.com> <46804923$1@newsgroups.borland.com> <bov0839c1ajn1k0b8ercnip94med9g05g2@4ax.com> <468090bf$1@newsgroups.borland.com> <o3r283leioornf8hkkfnn17jiktrnmkc7d@4ax.com> <46818a27$1@newsgroups.borland.com> <as3383h1vg5gfj48ppdov8po5d2pt01457@4ax.com> <4681a1cc@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,2270d561f33be473
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: Paul <nospam@sdiespammersdie.com>
Newsgroups: borland.public.interbase.sql
Subject: Re: Update one table based on data in another
Date: Wed, 27 Jun 2007 09:10:51 +0100
Organization: None
Message-ID: <v96483lgssas9gb83fh7dlrm4asohihh3p@4ax.com>
References: <bec083t4td4iqapnt5pu2sm66tp172oudu@4ax.com> <46804923$1@newsgroups.borland.com> <bov0839c1ajn1k0b8ercnip94med9g05g2@4ax.com> <468090bf$1@newsgroups.borland.com> <o3r283leioornf8hkkfnn17jiktrnmkc7d@4ax.com> <46818a27$1@newsgroups.borland.com> <as3383h1vg5gfj48ppdov8po5d2pt01457@4ax.com> <4681a1cc@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.92/32.572
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 86.150.143.163
X-Trace: newsgroups.borland.com 1182931852 86.150.143.163 (27 Jun 2007 01:10:52 -0700)
Lines: 28
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message