Re: Updating from two tables

RiseY3K_at_gmail.com wrote:
> Hi,
>
> TABLE table_a
> (
> change_date DATE NOT NULL,
> id NUMBER(3) NOT NULL,
> pri_order VARCHAR2(5),
> sec_order VARCHAR2(5),
> ...
> media_id NUMBER(4) NOT NULL
> );
>
> TABLE table_b
> (
> change_date DATE NOT NULL,
> id NUMBER(3) NOT NULL,
> pri_order VARCHAR2(5),
> sec_order VARCHAR2(5),
> ...
> name VARCHAR(21)
> );
>
> I would like to update table_b from table_a with pri_order and
> sec_order for every matching id. This looks like a fairly easy sql
> statement, but I have tried many sql statement and looked for help and
> but couldn't get it to work. I am using an oracle database.
>
> Thanks in advance,
> - Kevin
>

Morgan's Library at www.psoug.org. Click on UPDATE STATEMENTS.

You will find a working demo.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org