AnsweredAssumed Answered

Help with ExecuteSQL (join needed ?)

Question asked by dezkev on Aug 19, 2017
Latest reply on Aug 20, 2017 by taylorsharpe

Hello,

Have these two tables:

Table:Sales

ID

salesamount

salesdate

employeeID

 

Table:Emp

ID

EmpName

 

I  would like a report using Execute SQL as below:

Employee      SalesTotal  Month

John               $12000         January

Peter              $10000         February

and so on.

 

Would I need a Join, since the employee name is in the other table ?

Thanks

Kevin

Outcomes