multiplying two column on diff tables based on a column in another tab

[home6722]

i have two columns

1) billableHours from TimeCardHours table
2) billingRate from Employees table.

i need to calculate the totalCost with the formula
(billableHrs * billingRate for the employee to whom the time card is issued) into totalcost column on timeCards table.
Any help on how to go about this?

 

[bborissov]

SELECT TimeCardHours.billableHrs * Employees .billingRate
FROM Employees 
INNER JOIN TimeCardHours ON TimeCardHours.EmplFK =
                            Employees.PK

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.