CREATE VIEW blablabla
AS SELECT
		SUM(CASE WHEN (EXP.RM02.RM02_TA05_PRICHDV = '21') 
			THEN EXP.RM02.RM02_KOL * EXP.RM02.RM02_CENA
			ELSE EXP.RM02.RM02_KOL * EXP.RM02.RM02_CENA * - 1 
			END) AS SM,
		SUM(CASE WHEN (EXP.RM02.RM02_TA05_PRICHDV = '21')
			THEN EXP.RM02.RM02_KOL
			ELSE EXP.RM02.RM02_KOL * - 1 
			END) AS KL,
			EXP.RM02.RM02_ZA03_POLUCH AS ZKZ,
			EXP.RM02.RM02_TA01_MPN
	FROM EXP.RM02, EXP.TA21
	WHERE
		EXP.RM02.RM02_DATADV BETWEEN '".$aFromDate."' AND
		'".$aTillDate."' AND
		EXP.RM02.RM02_TA17_SKLAD = '15975' AND
		EXP.RM02.RM02_TA05_PRICHDV IN ('21','71') AND
		SUBSTR(EXP.TA21.TA21_IZGOT, 1 , 4 ) = '$aExecutor' AND
		EXP.RM02.RM02_ZA09_NOMZAK = EXP.TA21.TA21_ZA09_NOMZAK AND
		EXP.RM02.RM02_TA01_MPN = EXP.TA21.TA21_ZA05_KODIZD AND
		EXP.RM02.RM02_TA15_MESTO  = EXP.TA21.TA21_TA15_MESTO
		GROUP BY EXP.RM02.RM02_ZA03_POLUCH, EXP.RM02.RM02_TA01_MPN