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
>