By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,695 Members | 1,956 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,695 IT Pros & Developers. It's quick & easy.

repost(gmane): sql update max smartries

P: n/a
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 8: explain analyze is your friend

Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.