Link to home
Start Free TrialLog in
Avatar of MrTV
MrTVFlag for Thailand

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
Avatar of PortletPaul
PortletPaul
Flag of Australia image

you should have the factor for multiplication in a different field, is that possible?
ASKER CERTIFIED SOLUTION
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MrTV

ASKER

Thank you