V
visidro
I have a report where I would like list various fields from two tables. I
have joined these two tables by FirstName and assistant's names. I am unable
to get the billingrate using the select statement bellow:
SELECT Employees.BillingRate FROM Employees INNER JOIN [Work Time Sheet] ON
Employees.FirstName = [Work Time Sheet].[assistant's names];
I have tried different joins (left, right), I am not sure what I am doing
wrong, could you help please?
thank you
victor
have joined these two tables by FirstName and assistant's names. I am unable
to get the billingrate using the select statement bellow:
SELECT Employees.BillingRate FROM Employees INNER JOIN [Work Time Sheet] ON
Employees.FirstName = [Work Time Sheet].[assistant's names];
I have tried different joins (left, right), I am not sure what I am doing
wrong, could you help please?
thank you
victor