Updating

From: MoneyFool <gandhikartik_at_yahoo.com>
Date: 1 Oct 2003 11:47:14 -0700
Message-ID: <d8a7f25e.0310011047.22100ac8@posting.google.com>

I have 2 tables in Oracle database

Table A
ID Path

2  \vfs\gim2k
3  \vfs\gim2k
4  \vfs\gim2k
5  \vfs\gim2k
6  \vfs\gim2k

Table B
ID Path
3 menu
4 j menu
5 q menu
6 abc menu

how can I update table A and set the Path to the same from Table B for all the ID's common in A and B?

The below one works for 1 id but not multiple? update A

set path = (	select path
		from B
		where id IN ('3'))

where id IN ('3')

Thanks Received on Wed Oct 01 2003 - 13:47:14 CDT