Re: Updating

MoneyFool wrote:

>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
>
>

Please give students pointers and hints ... not complete answers.

Thanks.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)