How to join two query in SQL (Oracle)

Posted by MAHESH A SONI on Stack Overflow See other posts from Stack Overflow or by MAHESH A SONI
Published on 2010-06-03T07:04:09Z Indexed on 2010/06/03 7:14 UTC
Read the original article Hit count: 188

Filed under:

oracle9i

How can I join these queries?

SELECT RCTDT, SUM(RCTAMOUNT), COUNT(RCTAMOUNT) FROM RECEIPTS4
WHERE RCTDT BETWEEN '01-nov-2009' AND '30-nov-2009' 
AND RCTTYPE='CA' AND RCTAMOUNT>0
GROUP BY RCTDT

---

SELECT RCTDT, SUM(RCTAMOUNT), COUNT(RCTAMOUNT) FROM RECEIPTS4
WHERE RCTDT BETWEEN '01-nov-2009' AND '30-nov-2009' 
AND RCTTYPE='CQ' AND RCTAMOUNT>0
GROUP BY RCTDT

Related posts about oracle9i

Oracle9i export error

as seen on Server Fault - Search for 'Server Fault'
When I rut the following: set ORACLE_SID=orcl exp.exe 'SYS/system as sysdba' full=y log=exp.log file=mydump.dmp in the end i see the following: EXP-00056: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00000: Export terminated unsuccessfully what should i do to resolve… >>> More
migrating from mysql to oracle9i.Equivalent create table syntax

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Following is the syntax for creating table in mysql. I want to create table with same properties in oracle9i. Can anyone provide me the equivalent syntax for oracle? CREATE TABLE IF NOT EXISTS "tbl_audit_trail" ( "id" int(11) unsigned NOT NULL, "old_value" text NOT NULL, … >>> More
how query a cube olap using a java Application

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I've a cube olap created with oracle9i, and I want to do some queries on this cube using a java application, but the problem is: how can I connect the java application with the cube olap. thanks for your help >>> More
Oracle 9i Session Disconnections

as seen on Server Fault - Search for 'Server Fault'
I am in a development environment, and our test Oracle 9i server has been misbehaving for a few days now. What happens is that we have our JDBC connections disconnecting after a few successful connections. We got this box set up by our IT department and handed over to. It is 'our problem', so options… >>> More
Linked SQL Server to Oracle

as seen on Server Fault - Search for 'Server Fault'
Getting this error when executing SQL Server query only when connected via remote Desktop. When running the query from desktop, no problem. Is this a tsnNames issue? Linked server to Oracle 9i Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' reported an error. [OLE/DB provider… >>> More

Developer IT

How to join two query in SQL (Oracle) - Developer IT

How to join two query in SQL (Oracle)

oracle9i

Related posts about oracle9i

Oracle9i export error

migrating from mysql to oracle9i.Equivalent create table syntax

how query a cube olap using a java Application

Oracle 9i Session Disconnections

Linked SQL Server to Oracle

Categories cloud