Hi,
I am building a scoreboard to show te results of the sales group in my company.
There are 3 tables:
- sales employees
- Offertes
- sales
What i want is a query which calculates the total number of offertes and sales for each sales employee in a period (year/month / week)
Is there a way doing this in one query are is this only possible with sub queries?
grtz klaas
I am building a scoreboard to show te results of the sales group in my company.
There are 3 tables:
- sales employees
- Offertes
- sales
What i want is a query which calculates the total number of offertes and sales for each sales employee in a period (year/month / week)
Is there a way doing this in one query are is this only possible with sub queries?
grtz klaas