Help with an Update statement

From: harry <a_at_abc.com>
Date: Sat, 01 Dec 2001 13:27:15 GMT
Message-ID: <4nmh0uo8122845eq5hmabicufoa7u5kdeu@4ax.com>

Using Oracle 8i on NT 4 server (sp6a)

I'm having a major problem getting this to work -

I have 2 tables

Test1

---

ID
cert_no

Test2

---

ID
cert_no

..................containing records

Test1

---

ID	cert_no
-- 	-----------
1	123
2	456
3	789

Test2

---

ID	cert_no
-- 	-----------

1
1
1
2
2
3
3

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

should end up like -

Test2

---

ID	cert_no
-- 	-----------
1	123	
1	123
1	123
2	456
2	456
3	789
3	789

Can anyone help?- this looks fairly straightforward but for the life of I can't get it to work!

Thanks

Harry Received on Sat Dec 01 2001 - 07:27:15 CST