Nishant.Chauhan80 Ответов: 1

Как объединить две записи запроса в один результат

1)запрос:- 
Select SUM(expen.amount) as premonth from expen  where schemeno='W2/2013/11584' and exp_date<'2013-04-01' and  passingDate is not null


Результат

Предчувствие
--------
Нулевой


2)запрос:-
Select SUM(expen.amount) as expenamt, monyr,schemeno,sch_mas.sch_amount,sch_mas.san_no,sch_mas.disp
    from expen  inner join sch_mas on sch_mas.sch_no=expen.schemeno where exp_date>'2013-03-31' and exp_date<'2014-03-31'
	and schemeno='W2/2013/11584' group by expen.monyr,expen.schemeno,sch_mas.disp,sch_mas.sch_amount,sch_mas.san_no


Результат


expenamt |monyr |schemeno
--------- --------
716274 | 201307|W2/2013/11584

Что я уже пробовал:

how to join two query records in single result


Premonth |expenamt |monyr |schemeno
--------- -------- ------- ----------
Нуль| 716274 | 201307| W2/2013/11584

Maciej Los

Пожалуйста, не делайте репостов!
https://www.codeproject.com/Questions/1243401/Please-help-in-my-combine-SQL-query
https://www.codeproject.com/Questions/1242927/How-to-combined-two-queries-in-one-result-with-dif

Nishant.Chauhan80

srry сэр но этот пост кратко объясните пожалуйста смотрите этот пост

1 Ответов

Рейтинг:
7

kirthiga S 

;with cte as (
Select SUM(expen.amount) as premonth from expen  where schemeno='W2/2013/11584' and exp_date<'2013-04-01' and  passingDate is not null
),cte2 as (
Select SUM(expen.amount) as expenamt, monyr,schemeno,sch_mas.sch_amount,sch_mas.san_no,sch_mas.disp
    from expen  inner join sch_mas on sch_mas.sch_no=expen.schemeno where exp_date>'2013-03-31' and exp_date<'2014-03-31'
	and schemeno='W2/2013/11584' group by expen.monyr,expen.schemeno,sch_mas.disp,sch_mas.sch_amount,sch_mas.san_no
)select * from cte,cte2

Nishant.Chauhan80

спасибо сэр