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