PB how to call in another table data from table calculated?-CodePudding

Such as the individual account table: (employee number, name, gender, salary)
Payroll: (employee number, salary)
How to pay in the table "wages" table "wages" imported into the personal account?

CodePudding user response:

Employee number,

 select a. a. name, a. gender, from individual account table a 
Left the join payroll on a. b employee number=b. employee number 


Update a 
The set a. paid 
=b.The from individual account table a, individual account table b 
Where a. Employee number=b. employee number

CodePudding user response:

Employee number,

 select a. a. name, a. gender, b. wages from individual account table a 
Left the join payroll on a. b employee number=b. employee number 


Update a 
The set a. paid 
=b.The from individual account table a, individual account table b 
Where a. Employee number=b. employee number

CodePudding user response:

Different database, there are different writing. Oracle and essentially and DB_2 are different.
But thinking, two tables are associated, to link the record update.