"Kiart" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > NT> ËÁË ÐÒÁ×ÉÌØÎÏ ÅÇÏ ÐÅÒÅÐÉÓÁÔØ, ÔÁË > ËÁË ÏÞÅÎØ ÄÏÌÇÏ ×ÙÐÏÌÎÑÅÔÓÑ, ÂÏÌØÛÏÊ > ÓËÁÎ > NT> ÔÁÂÌÉÃÙ docum_items. FB2 > > á ÞÔÏ ÂÕÄÅÔ, ÅÓÌÉ × ÐÏÄÚÁÐÒÏÓÅ > ÉÓÐÏÌØÚÏ×ÁÔØ ÁÌÉÁÓÙ, ÎÅ ÓÏ×ÐÁÄÁÀÝÉÅ Ó > ÏÓÎÏ×ÎÙÍ ÚÁÐÒÏÓÏÍ? îÁÐÒÉÍÅÒ ÔÁË: > > (select distinct di.id_product > from documents d2 > join docum_items di2 on (d2.id_docum = di2.id_docum) > join operations o2 on (d2.id_operation = o2.id_operation) > where o2.state in (3) > and d2.date_docum between :DateBegin and :DateEnd) > > á ÔÏ Ñ ÂÙ ÎÁ ÍÅÓÔÅ FB ÎÅ ÐÏÎÑÌ, ÞÔÏ Ó ÞÅÍ > ÔÙ ÖÅÌÁÅÛØ Ó×ÑÚÁÔØ × ÐÏÄÚÁÐÒÏÓÅ, ÒÁÚ > ÁÌÉÁÓÙ ÏÄÉÎÁËÏ×ÙÅ.
á ÐÏÈÏÖÅ ÞÔÏ ÏÎ ÐÏÎÉÍÁÅÔ :)