SHOW:
|
|
- or go back to the newest paste.
| 1 | SELECT count(*) | |
| 2 | - | FROM produkty p |
| 2 | + | FROM zamowienia z |
| 3 | - | JOIN klienci k ON (k.id_klienta = p.id_klienta) |
| 3 | + | JOIN klienci k ON (k.id_klienta = z.id_klienta) |
| 4 | - | JOIN oceny o ON (o.id_produktu = p.id_produktu) |
| 4 | + | JOIN oceny o ON (o.id_produktu = z.id_produktu) |
| 5 | JOIN ankiety a ON (a.id_ankiety = o.id_ankiety) | |
| 6 | WHERE k.imie = 'JAN' | |
| 7 | AND k.nazwisko = 'NOWAK' | |
| 8 | AND a.imie_ankietujacego = 'ADAM' | |
| 9 | AND a.nazwisko_ankietujacego = 'NOWAK' |
