select ico, nazev,dic
FROM zakaznici
WHERE (NOT IsNull(ucet)) and 
((Vztah = 'z') or (vztah ='Z'))

Select
    pr.prijemka, datum_prij, dodavatel, po.*
FROM 
    Prijemky AS pr inner Join Pol_prij AS po
        on pr.prijemka = po.prijemka
ORDER BY pr.prijemka, sir_pas

SELECT
    pr.prijemka
FROM
    prijemky AS pr LEFT JOIN pol_prij AS po
        ON pr.prijemka = po.prijemka
WHERE
    ISNULL(sir_pas)

SELECT
    prijemka
FROM
    prijemky 
WHERE
    prijemka NOT IN 
        (SELECT DISTINCT prijemka FROM pol_prij)
ORDER BY 
    prijemka

SELECT
    delka, profil, count(*) AS Pocet, 
    SUM(hmotnost/1000) AS CelkHmotnost,
    SUM(Poc_kusu*delka/1000) AS BezMetry 
FROM
    baliky
WHERE
    (Stav_Bal = 'D') AND (delka <> 6000)
GROUP BY
    delka, profil

Select 
    Profil,Delka,Kod_Vyr,
    Sum(Hmotnost/1000)  as Hmotnost_tuny,
    Sum(Poc_kusu) as Počet_Kusů, Count(*) as Počet_svazků
From 
    Baliky
Where 
    Trida = "I. " and Stav_Bal = "D"
Group by 
    Profil,Delka,Kod_Vyr
Having 
    Count(*) > 20
Order by 
    Profil,Delka

SELECT
    z.ico, SUM(hmotnost)/1000 AS Tuny
FROM
    zakaznici AS z INNER JOIN Baliky AS b
        ON z.ico = b.ico
WHERE
    (Mid(Dat_Vyr_znak,7,2) = "06") AND (stav_bal = 'E')
GROUP BY
    z.ico
 
SELECT
    sir_pas, stena, SUM(mnoz_obj) AS Objednano,
    SUM(mnoz_dod) AS Dodáno
FROM
    objedn_out o INNER JOIN pol_obj_out po
        on o.c_int = po.c_int
GROUP BY
    sir_pas, stena
HAVING
    SUM(mnoz_obj) - SUM(mnoz_dod) > 5000

SELECT DISTINCT
    m.trubka,profil,v.nazev
FROM
    (material AS m INNER JOIN vyrobky As v
        ON m.trubka = v.trubka) INNER JOIN baliky AS b
            on b.kod_vyr = v.kod_vyr

SELECT
    cis_svazku, Count(*)
FROM
    Baliky
Group BY
    cis_svazku
HAVING
    Count(*) > 1

SELECT
    Baliky.CIS_SVAZKU, Baliky.ID, Baliky.C_VYR_PRIK
FROM 
    Baliky
WHERE (((Baliky.CIS_SVAZKU) In (SELECT [CIS_SVAZKU] FROM [Baliky]  GROUP BY [CIS_SVAZKU] HAVING Count(*)>1 )))
ORDER BY Baliky.CIS_SVAZKU;