Hi before starting  i wanna tell you about my structure

i have 3 different tables customer,bill and coupon.

that each bill has a customerid and date.

and each coupon has a date field too.

i wanna take the count of coupons,count of  bills and count of bills grouped by customer(this gives the visit count of the customer).
i want to make crosstab that groups data in days of last week. and these would be my data. since i cannot group all data with one shared field. I cannot make this crosstab any idea would be helpful.
Thank You.

hi John thank you for your reply,
No particular reason for crosstab.Question is that since i have to take the counts of data i cannot take all data with one sql command and i want to group the report by  date but i don't have a shared date object each table is grouped by date but with different fields.

To summarize i want report like that:
                 visitor count     coupon count    bill count
sun          112                        456                 46

mon         456                         54                   5

tue           ..                            ..                      ..

...

how can achieve that
Thank You

yes bill table has a unique identifier  billId
yes coupon table has a customerId

and it has a uniqeu identifier as couponId

Hi everyone, i had postponed this issue for a while but i have to face it :)

finally i have a solution and i wanna share i hoep it helps someone

as i described my problem i need to take the sum of bills,count of bills,count of coupons,and number of visitors ad group by date.

For this i wrote and subquery that takes su of bills, count of bills  and groups by date this is subqery 1.

Another one takes the count of coupons and groups by date this is subqery 2.

last one takes the visitor count and groups by date too and this is subquery 3

then ı join these there subqery on date and select the values

select * from
subqery3 join
(select *
from
subqery1 join subqery 2 on date
group by date
) on date