SELECT aDATE, DATEcol, VALUEcol
FROM aTABLE,
(SELECT TO_DATE('09/01/2005', 'mm/dd/yyyy') aDATE FROM DUAL UNION SELECT
TO_DATE('09/02/2005', 'mm/dd/yyyy') aDATE FROM DUAL UNION SELECT
TO_DATE('09/03/2005', 'mm/dd/yyyy') aDATE FROM DUAL UNION SELECT
TO_DATE('09/04/2005', 'mm/dd/yyyy') aDATE FROM DUAL UNION SELECT
TO_DATE('09/05/2005', 'mm/dd/yyyy') aDATE FROM DUAL) WHERE aDATE = DATEcol (+)
ORDER BY aDATE
Sam
Ok, I think that might be what I was looking for. A bit clunky, but not nearly
as clunky as all the other solutions I have attempted today.
I will be replacing this with a Stored Procedure, but this allows me more time
to learn how to do that, and not have to figure out SP's and then right a
fairly advanced one, all in one day. Yeah!!!
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223102
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
