Re: Need help with SQL and Oracle 8i

From: Tony <none_at_none.com>
Date: Tue, 14 Jan 2003 05:00:10 GMT
Message-ID: <68672v481hcen3ibfn5pr2h5h98l21tun0@4ax.com>

On Mon, 13 Jan 2003 15:09:19 -0800, DA Morgan <damorgan_at_exesolutions.com> wrote:

>Tony wrote:
>
>> Using Oracle 8i
>>

<snip>
>> Any help on looping through the tables programs would be appreciated.
>> I'm still pretty much a newbie, so type slowly :)
>>
>> Tony!
>
>Why does this require looping through anything?
>
>Why wouldn't a simple SQL statement work with a sub-query based on
>program and max(datetime) with a group by?
>
>PS: I deleted our cross-posting to c.d.o.miscellaneous 'cause I can take
>a hint.
>
>Daniel Morgan

A loop just seemed like the way to go about it.. (Like I said,., I'm not all that skilled yet in sql :)

Will look into nested queries.

Thanks for the ideas,

Tony! Received on Mon Jan 13 2003 - 23:00:10 CST