Re: Help with an Update statement

From: Michael G. Schneider <mgs_at_mgs-software.de>
Date: Sat, 1 Dec 2001 14:52:40 +0100
Message-ID: <9uamkc$je5$02$1@news.t-online.com>

"harry" <a_at_abc.com> schrieb im Newsbeitrag news:4nmh0uo8122845eq5hmabicufoa7u5kdeu_at_4ax.com...

> I need an update query to populate the cert_no column in Test2 based on
matching ID's. Ive tried all
> sorts of things & generally end up with "single row select statement
returns mutiple rows" error

Not acutally tested, but rather sure that it will work:

update test2 set cert_no=(select cert_no from test1 where test1.id=test2.id);

Michael G. Schneider Received on Sat Dec 01 2001 - 07:52:40 CST