yes !
From: Antoine Theytaz <antoine.theytaz_at_gmvs.migros.ch>
Date: Fri, 26 Nov 1999 16:44:38 GMT
Message-ID: <81mddm$im7$1_at_nnrp1.deja.com>
Date: Fri, 26 Nov 1999 16:44:38 GMT
Message-ID: <81mddm$im7$1_at_nnrp1.deja.com>
In article <81matb$gvp$1_at_nnrp1.deja.com>,
pberetta_at_my-deja.com wrote:
> This might work:
> select store_num, col1, col2
> from states a
> where trading_date =
> ( select next_date from states b
> where to_char(b.trading_date, 'YYYYMMDD') = '19991108'
> and b.store_num = a.store_num);
>
<snip>
... yes, it seems to work well !
thank you Antoine
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Nov 26 1999 - 17:44:38 CET