Michael Stassen wrote:
Daniel Bowett wrote:
Michael Stassen wrote:
Daniel Bowett wrote:
Peter Brawley wrote:
Dan,
/>...Total sales for ever would be a simple GROUP BY query with a
>sum on the sales - but I cant see how I am going to get this info.
>Do I need to use neste
Michael Stassen wrote:
Daniel Bowett wrote:
Peter Brawley wrote:
Dan,
/>...Total sales for ever would be a simple GROUP BY query with a
>sum on the sales - but I cant see how I am going to get this info.
>Do I need to use nested queries? /
You don't need nested queries. I
Peter Brawley wrote:
Dan,
/>...Total sales for ever would be a simple GROUP BY query with a
>sum on the sales - but I cant see how I am going to get this info.
>Do I need to use nested queries? /
You don't need nested queries. It's a crosstab or pivot table query. The
trick is to sum into on
I am unsure how to write this query, can someone help?
I have two tables.
One has a list of retailers (tbl_retailer):
retailerid
name
postcode
e.g.
1 Sprocket Supplies CH23 4PY
The other has the sales by month for each retailer:
retailerid
month_2
sales
e.g.
1 2004-01 100
1 200
