MrTV
asked on
Multiply buy factor if have in list postgresql
I have a table BB it concist of name
Table BB
Name (varchar)
David 1.2
Susan 1.1
Table salary
David 10000
Susan 10500
michale 13000
How can I calculate the salary please see michale he is not in the list
totoal salary
David 10000 * 1.2
suasan 10500 *1.1
michale 13000 * 1g
Table BB
Name (varchar)
David 1.2
Susan 1.1
Table salary
David 10000
Susan 10500
michale 13000
How can I calculate the salary please see michale he is not in the list
totoal salary
David 10000 * 1.2
suasan 10500 *1.1
michale 13000 * 1g
you should have the factor for multiplication in a different field, is that possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you