Обсуждение: Re: repost(gmane): sql update max smartries

Поиск
Список
Период
Сортировка

Re: repost(gmane): sql update max smartries

От
Vic Cekvenich
Дата:
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
>>
>
>