"Oleg Matveyev" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > 1) ×ÏÔ ÐÒÑÍÏ ÔÁË - ×ÓÅ ÓÏÄÅÒÖÉÍÏÅ ÐÅÒÅÓÅÞÅÎÉÑ Ä×ÕÈ ÔÁÂÌÉÃ? > É ÎÉËÁËÉÈ ÄÏÐ.ÕÓÌÏ×ÉÊ (× WHERE) ... ? > ÔÏÇÄÁ ÞÅÇÏ ÔÙ ÏÖÉÄÁÅÛØ ËÒÏÍÅ Natural ÐÏ ÏÄÎÏÊ ÉÚ ÔÁÂÌÉÃ? > ÜÔÏ ÓÁÍÏÅ ÜÆÆÅËÔÉ×ÎÏÅ
óÏÒÒÉ, ÐÏÄÎÏÓÔØÀ ÐÒÏÃÅÄÕÒÁ Ú×ÕÞÉÔ ÔÁË: select p.name, p.Price_Retail, p.FullName, p.ID_Product, p.Flag, g.name, g.discount from products p join groups g on p.id_group=g.id_group where p.id_product in (select id from recurs_group(:ID_GROUPS)) order by g.name, p.name > 3) ÚÁÄÕÍÁÊÓÑ - ÔÁË ÌÉ ÕÖ ÔÅÂÅ ÎÕÖÎÁ ÓÏÒÔÉÒÏ×ËÁ ×ÓÅÇÏ ÜÔÏÇÏ ÒÅÚÁÌÔÓÅÔÁ? > ÐÏÐÒÏÂÕÊ ÂÅÚ ÓÏÒÔÉÒÏ×ËÉ É ÓÒÁ×ÎÉ ÏÝÕÝÅÎÉÑ :-) Ó where ÏÞÅÎØ ÎÕÖÎÁ, ËÌÉÅÎÔ ÚÁÄÁÞÕ ÐÏÓÔÁ×ÉÌ > P.S. ÕËÁÚÁÌ ÂÙ ÈÏÔØ ÓÅÌÅËÔÉ×ÎÏÓÔØ ÉÎÄÅËÓÏ× É/ÉÌÉ ËÏÌ-×Ï ÚÁÐÉÓÅÊ × > ÔÁÂÌÉÃÁÈ.... × products ÍÏÖÅÔ ÂÙÔØ ÄÏ 100000 ÚÁÐÉÓÅÊ, × groups ÄÏ 1000
