Hi Adam,

I'll try simplier.

> > Here is sample data:
> > Article
> > id name price
> > 1 name1 10.00
> > 2 name2 20.00
> > 3 name3 30.00
> >
> > Document
> > article qty newprice
> > 1 10 15.00
> > 2 10 25.00
> > 3 10 35.00
> >

SQL that I need must upade price from table document UPDATE Article
SET Article.Price = (SELECT Price FROM Document WHERE Document.Article
= Article.id);

My SQL shoul be work like this:
for i := 1 to Document.recordcount
begin
UPDATE Article SET Article.Price = (SELECT Price FROM Document WHERE
Document.Article = Article.id);
end

Is this posible in one SQL statment.

P.S. My english is vey bad, but I'm trying to represent my problem
with Delphi code below!

Thanks again