PEAKTOP wrote:
SELECT MAX(T.NAME) AS NMTMC, SUM( IIF(Q.PLACE_ID = '1', Q.QUANTITY, 0)) AS QNT000001, SUM( IIF(Q.PLACE_ID = '2', Q.QUANTITY, 0)) AS QNT000002, SUM(Q.QUANTITY) AS QNTNONAL FROM TABL$TMC_QUANT Q INNER JOIN TABL$TMC T ON Q.TMC_ID = T.ID GROUP BY Q.TMC_ID План PLAN SORT (JOIN (T NATURAL, Q INDEX (INDX$TMC_QUANT_TMC_ID))) Адаптированный план PLAN SORT (JOIN (T NATURAL, Q INDEX (INDX$TMC_QUANT_TMC_ID)))
Сдаёццо мне, что On Q.TMC_ID+0 = T.ID радикально изменит ситуацию... -- Regards. Ded.
