Как объединить два запроса в один результат с разными столбцами и условиями
запроса query1:-
Select expen.schemeno, sum(expen.amount) as Premonth,sch_mas.disp,sch_mas.sch_amount, sch_mas.san_no , CONVERT(varchar, sch_mas.sdate, 106)as schdate from [dbo].[expen] inner join sch_mas on expen.schemeno=sch_mas.sch_no where schemeno='W2/2013/11516' and exp_date<'2013-04-01' and passingDate is not null group by sch_mas.disp, expen.schemeno,sch_mas.sch_amount,sch_mas.sdate,sch_mas.san_no
Query2:-
Select monyr, SUM(expen.amount) as expenamt,schemeno from expen where exp_date>'2013-03-31' and exp_date<'2014-03-31' and schemeno='W2/2013/11516' group by monyr,schemeno
Что я уже пробовал:
combined two queries in one result with different columns and conditions