M
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
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