MySql Query problem

I have two Table A and B.
With table A I fired a query to get a count, and a query with table B to get a count.
now I want total of both count.
But I want to this all in one query.


Example:- I fired tqo queries as-

1- select DATE(Today_DATE), count(1) from table DAY1 group by DATE(Today_DATE);

2- Select DATE(Yesturday_DATE), count(1) from table DAY2 group by DATE(Yesturday_DATE);

Here both table give separate counts and we can add these count for single result,
But I want all this work in a single query

Questions by GAUTAMJANGRA   answers by GAUTAMJANGRA

Showing Answers 1 - 3 of 3 Answers

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions