Hi Guys,
I am struck with a mysql query…please help me out
I have two tables…1st table for clicks and 2nd table for sales
clicks
Date
UserID
BookID
Sales
Date
UserID
BookID
I want to get an output like the following
Date | clicks | Sales |
2010-02-01 | 20 | 2 |
2010-02-02 | 12 | 0 |
2010-02-01 | 14 | 1 |
I am trying the query with group by and left join…but not working
Please help me out