🚀 go-pugleaf

Jaka baza?
Podaj pełne DDL dla tabeli TRE.

-- 
wloochacz

PS. Poza tym wolę tak: ;-)

select GRUPA,
        MODEL,
        DZAL,
        DEKOR,
        OPIS,
        NTP,
        P,
        M,
        ZL,
        SUM(ILE) as ILE
from TRE
where M = 'Prod' and
       (ZL is null or
       ZL = '200707311') and
       MODEL not like 'ŁAWA%' and
       MODEL not like 'STOLIK%' and
       MODEL not like 'STÓŁ%' and
       MODEL <> 'IMPERIUM' and
       MODEL <> 'MONTANA' and
       MODEL <> 'VENETO' and
       MODEL <> 'DOMINO' and
       MODEL <> 'SPARTA' and
       MODEL <> 'WARKA' and
       MODEL <> 'SPARTAN' and
       MODEL not like 'CONF ŁAWA%' and
       MODEL <> 'REKLAMACJA ŁAWA' and
       GRUPA <> 'TAPI' and
       GRUPA <> 'KUCH' and
       ZAM is not null
group by GRUPA,
          MODEL,
          DZAL,
          DEKOR,
          OPIS,
          NTP,
          P,
          M,
          ZL
order by 1,
          2,
          3,
          4,
          5,
          6