Re: Updating one table with the data from another table with matching field

UPDATE Master_table

      SET salary = ( SELECT avg_salary/12 
                                FROM  Payroll_table as N
                             WHERE  master_table.Ssn = N.ssn)
      WHERE EXISTS (SELECT avg_salary
                                     FROM  Payroll_table as N
                                  WHERE  Master_table.Ssn = N.Ssn) 

Example at http://www.inquiry.com - Tech tips SQL

Cecil

SKMGMT <skmgmt_at_aol.com> wrote in article <19970917015900.VAA19564_at_ladder01.news.aol.com>...
> Kindly help with the following problem:
> If there is a master table with employee info and another table called
> payroll consisting of 2 fields social.sec.num and salary.
> Master_Table: Name Varchar2(20)
> Age Number(3)
> Salary Number (8)
> Ssn Number (10)
>
> Payroll_Table Ssn Number (10)
> Avg_Salary Number (8)
>
> Update the salary column of master table with avg_salary/12 for
> corresponding ssn. Use only SQL query. PL/SQL Block not allowed.
>
Received on Wed Sep 17 1997 - 00:00:00 CDT