Hi All,

I want data for the the last 1 year from the given date For ex:- I have date "2013-06-01" and i want data as follows also data i want is from three table using Group By or something else

Month             Amount         Total_Data
June 2013     100                5
May 2013       80                  4
-                     100                5
-                     100                5
July 2012       10                  2

I try following query but didn't workout

SELECT DATE_FORMAT(rf.period, '%M %Y') as Month
     , sum(p.amount * ((100-q.amount)/100)) as Amount 
     ,count(distinct q.label_id) as Total Data 
FROM table1 rf
   , table2 p
   , table3 q
   ,table4 a
where rf.period BETWEEN '2013-06-01' AND '2013-06-01' 
  and q.royalty_period BETWEEN '2013-06-01' AND '2013-06-01' 
  and a.id = q.album_id
  and p.file_id = rf.id
  and p.upc = a.upc
  and p.local_revenue is not null
GROUP BY Month 

Thanks in Advance,

Salil Gaikwad