I am trying to update a table "Burials" with an ownerid field from another table "Plotowners" Both tables have a field "Plotloc" which is a computed field I use this command but I get a syntax error Would someone please correct me???
update burials set ownerid=t2.ownerid from burials t1, plotowners t2 where t1.plotloc = t2.plotloc Thanks Bill
