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); |