THIS DON'T WORK
update inv i
set i.tax1 = i.total *s.tax1
set i.tax2 = i.total * s.tax2
from inv  i join system

SYSTEM FILE HAVE ONLY ONE RECORD.

CARLOS

Carlos

I think you must specify the conditions of join

> update inv i
> set i.tax1 = i.total *s.tax1
> set i.tax2 = i.total * s.tax2
> from inv  i join system

update inv i
set i.tax1 = i.total *s.tax1
set i.tax2 = i.total * s.tax2
from inv  i join system s on (i.field1 = s.field2)

Eduardo

"Carlos" <carlos.aneses@gmail.com> wrote in message
news:902AF97B-9CEF-481B-9ED4-35348A2D9C97@news.elevatesoft.com...
> THIS DON'T WORK
> update inv i
> set i.tax1 = i.total *s.tax1
> set i.tax2 = i.total * s.tax2
> from inv  i join system
>
> SYSTEM FILE HAVE ONLY ONE RECORD.
>

update inv i
set i.tax1 = i.total * s.tax1,
  i.tax2 = i.total * s.tax2
from inv  i, system s

It is always a good idea to indicate what it is that is "not working" for
you.

Robert