Thread: repost(gmane): sql update max smartries

repost(gmane): sql update max smartries

From
Vic Cekvenich
Date:
I am trying to write a sigle command to update the max number from detail.

>
> Something like:
> update group set max_msgid=max(c.msgid)
>     from group g, content c
>     where g.id=c.g_id
>
> So group is master, content is detail. I want group to stroe
> max(msgid) from content.
>
> Syntax help plz?
> .V
>