CREATE VIEW "TW_SM_CENY" AS
SELECT TW.kod, TW.cbazowa, TW.cenaa, TW.cenab, TW.cenac, TW.cenad, TW.kodpaskowy, SM.stan
FROM SM INNER JOIN TW ON SM.idtw = TW.id
WHERE SM.magazyn=0;

SELECT     kod as [typ ceny], [8] as cenabaz, [1] as cenaa, [2] as cenab, [3] as cenac, [4] as cenad, kodpaskowy, stan
FROM         (SELECT     HM.TW.kod, HM.CN.cena, HM.TW.kodpaskowy, HM.SM.stan, HM.CN.typ
                       FROM          HM.CN RIGHT OUTER JOIN
                                              HM.TW ON HM.CN.idpm = HM.TW.id LEFT OUTER JOIN
                                              HM.SM ON HM.TW.id = HM.SM.idtw
                       WHERE      (HM.TW.id > 3200) AND (NOT (HM.TW.rodzaj IS NULL)) AND (HM.CN.aktywna = 1)) AS ZZ
PIVOT
(
MIN(cena)
FOR typ IN ([8], [1], [2], [3], [4])
) AS PivotTable;