View difference between Paste ID: 111snZNn and gdNnntEt
SHOW: | | - or go back to the newest paste.
1
SELECT C_KLIENTA FROM Tabuľka1
2
WHERE PRODUKT = 'KK' AND NOT PRODUKT = 'BU'
3-
INNER JOIN (SELECT C_KLIENTA, COUNT(C_KLIENTA) FROM Tabuľka1 GROUP BY C_KLIENTA HAVING COUNT(C_KLIENTA)>1) ON (C_KLIENTA=C_KLIENTA);
3+
INNER JOIN (SELECT C_KLIENTA, COUNT(C_KLIENTA) FROM Tabuľka1 GROUP BY C_KLIENTA HAVING COUNT(C_KLIENTA)>1) AS tabulka2 ON (Tabuľka1.C_KLIENTA=tabulka2.C_KLIENTA);