Update from multiple tables?

[MAB]

Doesnt the SQL version of Access 2000 support update queries using multiple
tables. For example I have 2 tables 'ledger' and 'vouchers' which can be
joined by the field v_no and also have a common field 'name'. Now If I want
to copy all the values of 'name' from ledger.name to vouchers.name I could
write a query

Update vouchers
set name = l.name
from ledger l, vouchers v
where l.v_no = v.v_no

This works in SQL server. Why doesn't it work in Access or may be the syntax
is
different?

thx of any help

[Dirk Goldgar]

"MAB" <sfsdfsfsfjlf...@yahoo.com> wrote in message
news:biepho$8g3mo$1...@ID-31123.news.uni-berlin.de

The join syntax is different in JET (Acess) SQL. Try this:

UPDATE vouchers v
INNER JOIN ledger l ON v.v_no = l.v_no
SET v.name = l.name;

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)