Vic Cekvenich 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 master, content is detail. I want group to stroe max(msgid) from content.
Syntax help plz? .V
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
