hi...
just tested this:
> UPDATE member SET votes count(votes) FROM ballot WHERE id = 1 ;
>
> (I can't test right now but I don't see why this wouldn't work ...)
genisys=> UPDATE members SET phone1 = deadmem.phone1 FROM deadmem WHERE deadmem.id_num = 7356 and
genisys-> members.id_num = 100;
UPDATE 1
with an '=' and defining which field belongs to which table it works! =) kudos
to alain...
--
Aaron J. Seigo
Sys Admin