SELECT tw_Symbol [symbol], tw_nazwa [Nazwa towaru],[1] AS Hurtownia, [2] Zabrze, [3] AS Magazyn3, [4] AS Magazyn4, [5] AS Bytom, [6] AS Czeladź, [7] AS Częstochowa, [8] AS Magazyn8, [9] AS Magazyn9, [10] AS Magazyn10, [11] AS Magazyn11, [12] AS Magazyn12, [13] AS Magazyn13, [14] AS Magazyn14, [15] AS Magazyn15, [16] AS Magazyn16
FROM
(SELECT tw_symbol, tw_nazwa, st_magid, st_stan FROM tw_stan INNER JOIN tw__towar ON tw_id=st_towid where tw_zablokowany=0) Stany
 PIVOT
 (
  SUM(St_stan )
  FOR St_MagId IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],[13],[14],[15],[16])
 ) pMag

SELECT
tw_Nazwa AS Nazwa,
SUM (ob_Ilosc) AS Ilosc,
SUM (ob_WartNetto) AS Netto,
SUM (ob_WartVat) AS VAT,
SUM (ob_WartBrutto) AS Brutto
FROM dok_Pozycja
INNER JOIN dok__Dokument ON ob_DokHanId = dok_Id
INNER JOIN tw__Towar ON ob_TowId = tw_Id
WHERE    (dok_Typ IN({CHL:Faktura zakupu#1#Faktura sprzedaży#2#Korekta faktury zakupu#5#Korekta faktury sprzedaży#6#:Typ dokumentu}))
AND dok_Status =1
AND  dok_DataWyst BETWEEN {DR:Data:2011-01-01:2011-12-31}
AND dok_MagId IN ({CHL_DB: SELECT mag_Id, mag_Nazwa FROM sl_Magazyn :Magazyn})
AND (dok__Dokument.dok_KatId IN ({CHL_DB: SELECT kat_Id, kat_Nazwa FROM sl_Kategoria:Kategoria}))
GROUP BY tw_Nazwa