-- Simon Drabble <simon@eskimo.com> wrote:
> Is it possible to update a column with another column's value, say
>
> UPDATE member SET votes = `SELECT count(votes) FROM ballot WHERE id
> = 1`;
>
> with or without aggregates?
Have you tried a more direct command ?
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 ...)
Alain
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com