Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Statement Help
Kobee wrote:
> Oracle 9i
>
> SELECT
> PROGRAM_ID, PROGRAM_TYPE, ANNUALBUDGETTYPE, DESCRIPTION, NAME,
> NVL(SPLIT_FEDERAL, 0) AS "SPLIT_FEDERAL", NVL(SPLIT_MUNICIPAL, 0) AS
> "SPLIT_MUNICIPAL", NVL(SPLIT_PROVINCIAL, 0) AS "SPLIT_PROVINCIAL",
> AFS_FLAG, CAPITALPLAN_FLAG, CER_FLAG, HPEMS_FLAG, START_DATE,
> RENTSUP_FLAG,
> BENCHMARK_FLAG, STATUS, NVL(SUBSIDY_CC, 0) AS "SUBSIDY_CC",
> LASTUPDATE, NVL(SUBSIDY_CE, 0) AS "SUBSIDY_CE",
> DATE_CREATED, TRANSACTION_TYPE, MODIFIED_BY, TRANSACTION_ID,
> TRANSACTION_ORDER
> FROM
> PROGRAM_LOG
> WHERE
> TO_DATE(TO_CHAR(LASTUPDATE, 'yyyy-Mon-dd'), 'yyyy-Mon-dd') BETWEEN
> TO_DATE(dtstartdate, 'yyyy-Mon-dd') AND TO_DATE(dtenddate,
> 'yyyy-Mon-dd')
> OR
> TRANSACTION_TYPE = 'U'
> ORDER BY
> TRANSACTION_ID,
> TRANSACTION_ORDER,
> LASTUPDATE DESC;
>
>
> I' ve tried several approaches, but so far the "OR" statement is coming
> closest to what I need. The only problem is that the OR clause will
> return records whether or not there is a corresponding "Update" row
> within the date range.
>
> Thanks
>
>
> DA Morgan wrote:
>> Kobee wrote: >>> Hi, >>> >>> I've been trying to get this SQL, but I just can't get it to work. >> Where is your SQL? >> >> We can't help you with it if you don't post it. >> >> And your Oracle version number? >> -- >> Daniel A. Morgan >> University of Washington >> damorgan_at_x.washington.edu >> (replace x with u to respond) >> Puget Sound Oracle Users Group >> www.psoug.org
![]() |
![]() |