On Thu, Oct 21, 2004 at 18:14:15 -0500,
Vic Cekvenich <[EMAIL PROTECTED]> wrote:
> 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 m
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
--
