Results 1 to 6 of 6
Thread: Join queries
Dec 31, 2012, 01:42 #1
hi there and happy new year.
I need join two queries for output only, it's possible?... I tried with syntax CASE WHEN but I fail... can you help me?
SELECT sum(visitorcount) AS total FROM tbl_session; SELECT SUM(visitorcount) AS tot_CURRENT_MONTH, MONTH (visitdate) AS MONTH FROM tbl_session WHERE MONTH (visitdate) = MONTH (CURRENT_DATE()) AND YEAR (visitdate) = YEAR (CURRENT_DATE()) GROUP BY MONTH (visitdate);