As you show my queries first will gives me all dates of current month and second gives me rooms that is blocked or confirm in perticular day now i m tring to combine these two queries and want to display whole months dates and when if there is record in
perticular day it will show me else it will show me zero(0).
Query given by
matifnadeem the out put of that query repeat the column when there is data.
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Join two queris having diffent rows and having group by in one
Feb 13, 2013 12:16 AM|LINK
Hi keval,
What actually do you wanna do?
Can you elebrate this more?
keval.trived...
Member
158 Points
87 Posts
Re: Join two queris having diffent rows and having group by in one
Feb 15, 2013 03:45 AM|LINK
As you show my queries first will gives me all dates of current month and second gives me rooms that is blocked or confirm in perticular day now i m tring to combine these two queries and want to display whole months dates and when if there is record in perticular day it will show me else it will show me zero(0).
Query given by matifnadeem the out put of that query repeat the column when there is data.
Please help me to solve this problem.
Thanx