Re: Retrieving complex resultset from oracle
From: Josh <jr8110_at_yahoo.com>
Date: 8 Oct 2002 10:56:59 -0700
Message-ID: <a1c10eb3.0210080956.60bf15d0_at_posting.google.com>
Date: 8 Oct 2002 10:56:59 -0700
Message-ID: <a1c10eb3.0210080956.60bf15d0_at_posting.google.com>
Its rather difficult for me to elaborate more, the best i can do is
give some sorta pseudo code related to my problem, the query would be
something along the lines of this
Lets say i have 1 parameter, _at_report_date of type DATE, i'd like to do
something along the following:
SELECT a.id, a.amount, b.description
And whatever results from that is what i'd like to use in either MS
Access or Crystal Reports. I just need some sorta skeletal example of
FROM table1 a, table2 b
WHERE a.id = b.id
AND a.date = _at_report_date
Thanks Received on Tue Oct 08 2002 - 19:56:59 CEST