[GENERAL] sql update max smartries

[Vic Cekvenich]

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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])