| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Self Joint SQL (outer joint)
I need to make up a report as follows:
Accounts This Month Accts Previous Month Accts Prior Year Month
------------------- -------------------- ----------------------
How can I get outer joint in the self joint query so that I can include every accounts which had transactions in the three months?
--
Best regards,
Received on Sat Apr 01 2000 - 19:56:19 CST
 |
 |