Re: [GENERAL] Dynamic update

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