FB2.0RC3
åÓÔØ ÐÒÏÃÅÄÕÒÁ:
update notices set state=3
where id_notice in
( SELECT n.ID_NOTICE
from notices n, styles s, categories c left join blocks b on
c.id_block=b.id_block
left join titles t on
c.id_title=t.id_title
left join subtitles st on
c.id_subtitle=st.id_subtitle
where n.id_style = s.id_style
and n.id_category = c.id_category
and n.state = 2
and (n.date_notice between '26.07.2006' and '02.08.2006')
)
× ×ÙÂÏÒËÅ ËÏÔÏÒÏÊ ×ÓÅÇÏ 159 ÚÁÐÉÓÅÊ, ÎÏ ÏÔÒÁÂÁÔÙ×ÁÅÔ ÂÏÌÅÅ 6 ÍÉÎÕÔ. ðÒÉ ÜÔÏÍ
ÅÓÌÉ ÓÄÅÌÁÔØ ×ÙÛÅÕËÁÚÁÎÎÙÊ select ÏÔÄÅÌØÎÏ, ÔÏ ×ÙÐÏÌÎÅÎÉÅ 2-3 ÓÅËÕÎÄÙ.
åÓÌÉ ÐÅÒÅÐÉÓÁÔØ ×ÏÔ ÔÁË:
update notices set state=3
where id_notice in
( SELECT n.ID_NOTICE
from notices n
where n.state = 2
and (n.date_notice between '26.07.2006' and '02.08.2006')
)
ÔÏ ÏÔÒÁÂÁÔÙ×ÁÅÔ ÔÏÖÅ 2-3 ÓÅËÕÎÄÙ. þÅÍ ÓÅÒ×ÅÒÕ ÎÅ ÎÒÁ×ÉÔØÓÑ ÐÅÒ×ÙÊ ÚÁÐÒÏÓ?
