🚀 go-pugleaf

I think you need something like this:


select o1.article_no, o1.order_date, o1.price
from order o1
where o1.order_date =
(select min(o2.order_date)
 From Order o2
 Where o2.article_no = o1.article_no)


not tested. good luck.


Joseph


"RL912" <rl@werkstatt22.de> wrote in message
news:46a8795d$1@newsgroups.borland.com...
> Hello,
> I have a table containing Order Data. For this case significant are
> Article_no, order_date and price.
> The order records are generated from customers orders, so that the order
> "5 pcs of 12345, ordered on 01.01.2000 for 12,50$" is translated into "1
> of 5 of 12345 from 01.01.2000 for 12,50$;2 of 5 of 12345 from 01.01.2000
> for 12,50$;3 of 5 of 12345 from 01.01.2000 for 12,50$" and so forth.
> Now I need to query price changes from this table in a way, that I get a
> list containing
> article_no, order_date, price
> where order_date is the date, this price is used for this article for
> the first time.
>
> I am not really used to sql and did not find a solution.
>
> TIA
>
> Rolf