"sasha" <[EMAIL PROTECTED]> wrote: > > þÔÏ-ÔÏ ÞÅÍ ÂÏÌØÛÅ Ñ ÕÇÌÕÂÌÑÀÓØ × DERIVED TABLES, ÔÅÍ ÓÔÒÁÎÎÅÅ ÏÎÉ ÍÎÅ > ËÁÖÕÔÓÑ.
ô×ÏÉ ÐÒÏÂÌÅÍÙ, ÕÖ ÉÚ×ÉÎÉ. > SELECT T.ID, T.NAME, COALESCE(SUM_RUBLI, 0), COALESCE(SUM_UE, 0) > FROM TOVARI T > LEFT JOIN ( > SELECT SUM(SUM_RUBLI), SUM(SUM_UE) > FROM PRODAGI PR > WHERE PR.TOVAR_ID = T.ID) AS P (SUM_RUBLI, SUM_UE) > ON 1 = 1 SELECT T.ID, T.NAME, COALESCE(SUM_RUBLI, 0), COALESCE(SUM_UE, 0) FROM TOVARI T LEFT JOIN ( SELECT PR.TOVAR_ID, SUM(SUM_RUBLI), SUM(SUM_UE) FROM PRODAGI PR GROUP BY PR.TOVAR_ID) AS P (ID, SUM_RUBLI, SUM_UE) ON P.ID = T.ID > íÎÅ ËÁÖÅÔÓÑ ÞÔÏ ÜÔÏ ÐÒÉÚÎÁË ÔÏÇÏ ÞÔÏ ÒÅÁÌÉÚÁÃÉÑ ÜÔÉÈ DERIVED TABLES > ÎÅ ÏÞÅÎØ ÈÏÒÏÛÁÑ É ÓÍÙÓÌ ÓÉÎÔÁËÓÉÓÁ JOIN (SELECT ...) ËÁÖÅÔÓÑ > ÓÏÍÎÉÔÅÌØÎÙÍ. ÷ÓÅ ÐÒÅÔÅÎÚÉÉ Ë ËÏÍÉÔÅÔÕ ÐÏ ÓÔÁÎÄÁÒÔÉÚÁÃÉÉ, Á ÚÁÏÄÎÏ ËÏ ×ÓÅÍ óõâä, ÇÄÅ ÜÔÁ ÆÉÞÁ ÒÅÁÌÉÚÏ×ÁÎÁ. > èÏÔÅÌÏÓØ ÂÙ ÕÚÎÁÔØ ÍÎÅÎÉÅ ÚÎÁÀÝÉÈ ÐÏ ÜÔÏÍÕ ÐÏ×ÏÄÕ (ÏÓÏÂÅÎÎÏ Õ äå É äë ËÁË > ÈÏÒÏÛÉÈ ÔÅÏÒÅÔÉËÏ×). ÷ÓÅ ÓÄÅÌÁÎÏ × ÓÏÏÔ×ÅÔÓÔ×ÉÉ ÓÏ ÓÔÁÎÄÁÒÔÏÍ É ÓÏ ÚÄÒÁ×ÙÍ ÓÍÙÓÌÏÍ. äÖÏÊÎÉÔØ ÍÏÖÎÏ ÔÏÌØËÏ ÎÅÚÁ×ÉÓÉÍÙÅ ÔÁÂÌÉÃÙ. éÎÁÞÅ ÐÏÌÎÙÊ ÁÈÔÕÎÇ × ËÏÎÓÅÒ×ÁÔÏÒÉÉ. -- äÍÉÔÒÉÊ åÍÁÎÏ×
