Join two queary. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Join two queary.

Author

Topic

hspatil31
Posting Yak Master

182 Posts

Posted - 2010-07-23 : 05:08:22

Dear All,

I am having following 2 queries and output,

SELECT 'Admission Deposit' As ReportName,
Sum(RD.ADMISSIONDEPOSIT) As TodayRevenue
FROM SA.A_REVENUECOLLECTED_DEPOSIT RD
INNER JOIN D_DATE DT ON RD.DATEID = DT.DATE_ID
WHERE To_Char(DT.Full_Date,'DD/MM/YYYY') = (Select To_Char(SYSDATE,'DD/MM/YYYY') From Dual)

Output:

ReportName TodayRevenue
AdmissionDeposit 1200000

and

SELECT 'Admission Deposit' As ReportName,
Sum(RD.ADMISSIONDEPOSIT) As WeekRevenue
FROM SA.A_REVENUECOLLECTED_DEPOSIT RD
INNER JOIN D_DATE DT ON RD.DATEID = DT.DATE_ID
WHERE DT.WeekOfThWYear =(Select WeekOfThWYear From D_Date
where To_Char(Full_Date,'DD/MM/YYYY') = (Select To_Char(SYSDATE,'DD/MM/YYYY') From Dual))

Output:

ReportName WeekRevenue
AdmissionDeposit 18885000

Now i want output like,

ReportName TodayRevenue WeekRevenue
AdmissionDeposit 1200000 18885000

Can anybody tell me how to write query for this output in Oracle 10g ?

Thanks and Regard's
Harish Patil

Devart
Posting Yak Master

102 Posts

Posted - 2010-07-23 : 05:43:45

Hello,

try this:

SELECT
'Admission Deposit' As ReportName,
( SELECT
Sum(RD.ADMISSIONDEPOSIT)
FROM SA.A_REVENUECOLLECTED_DEPOSIT RD
INNER JOIN D_DATE DT ON RD.DATEID = DT.DATE_ID
WHERE To_Char(DT.Full_Date,'DD/MM/YYYY') = (Select To_Char(SYSDATE,'DD/MM/YYYY') From Dual) As TodayRevenue,
( SELECT
Sum(RD.ADMISSIONDEPOSIT)
FROM SA.A_REVENUECOLLECTED_DEPOSIT RD
INNER JOIN D_DATE DT ON RD.DATEID = DT.DATE_ID
WHERE DT.WeekOfThWYear =(Select WeekOfThWYear From D_Date
where To_Char(Full_Date,'DD/MM/YYYY') = (Select To_Char(SYSDATE,'DD/MM/YYYY') From Dual)))) As WeekRevenue
FROM dual;

Best regards,

Devart Team

hspatil31
Posting Yak Master

182 Posts

Posted - 2010-07-24 : 01:15:00

Dear Devart,

Thanks my problem is solved.

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources