list used products

jonasp

hi
I have 2 tables that are,

Create table products (idproduct int, nameproduct varchar(80), primary key (idproduct))
Create table use(product int, dateuse date, primary key(dateuse,product))

what i want to do is, a select that show if a product was uses in that day, and if was, show a 1 ou X, if not dont show anything, and in the last collum show the sum.
the date can be for a week, 2008/1/1, 2008/1/2, 2008/1/3, 2008/1/4, 2008/1/5, 2008/1/6, 2008/1/7.
what i wanna do is like this.

Prod|2008/1/1|2008/1/2|2008/1/2|2008/1/3|2008/1/3| SUM|
---------------------------------------------------------------------------|
1|______|X|X|____| X|3|
2|___|X|X|____| X|3|
3|X|_____|____|___| X|2|
4|X|_____|X|X| X|4|
5|____|X|X|____| X|3|
6|X|_____|____|___| X|2|
7|___|X__|X|X| X|4|
8|X|X_|X|____| X|4|

hope you can help me
cya

jonasp

now show me the X, but the days that i have 0 in the total, never been used, dont show me

right now i have

select products.idproduct as 'Product'
      ,CASE used.dateused WHEN '2008-01-01' THEN"X" ELSE " " END "01/01/2008"
      ,CASE used.dateused WHEN '2008-01-02' THEN"X" ELSE " " END "02/01/2008"
      ,CASE used.dateused WHEN '2008-01-03' THEN"X" ELSE " " END "03/01/2008"
      ,CASE used.dateused WHEN '2008-01-04' THEN"X" ELSE " " END "04/01/2008"
      ,CASE used.dateused WHEN '2008-01-05' THEN"X" ELSE " " END "05/01/2008"
      ,CASE used.dateused WHEN '2008-01-06' THEN"X" ELSE " " END "06/01/2008"
      ,CASE used.dateused WHEN '2008-01-07' THEN"X" ELSE " " END "07/01/2008"
      ,count(used.product) 'Total Used'
from products, used
where products.idproduct =used.product
group by products.idproduct;