Re: Doing a top N after self join

From: Jake <me_at_heyjay.com>
Date: Thu, 7 Aug 2003 00:48:47 -0500
Message-ID: <bgsp8h$s7l$1@bob.news.rcn.net>

My issue with dates is I only have M-F data, so I need to join Monday to the previous Friday

Har har about the cut and paste. If I change the table (add a column delete a column) stuff breaks with aliases

Thanks anyhow
Jay

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:6qi2jvca5gbn4p5iuskcopchkjquiibhnj_at_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 Thu Aug 07 2003 - 00:48:47 CDT