Re: Doing a top N after self join

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 06 Aug 2003 20:40:11 +0200
Message-ID: <6qi2jvca5gbn4p5iuskcopchkjquiibhnj@4ax.com>

On Wed, 6 Aug 2003 10:41:57 -0500, "Jake" <me_at_heyjay.com> wrote:

>My problem is after I do the join and sort desc, my columns are ambiously
>defined. I'd perfer not to have to alias every column from each table.
>
>Is there a way to access the today.* and yesterday.* columns?

If you know you can subtract dates, why are using such a complicated and messy method?
I don't think using aliases can be avoided, but most O/S-es have copy and paste nowadays.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Aug 06 2003 - 13:40:11 CDT