Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Sebastian
- SELECT kategorie_nazwa,
- (SELECT COUNT(posty_id) FROM posty WHERE posty.kategorie_id = k.kategorie_id GROUP BY kategorie_id) as ilePostow
- FROM kategorie AS k
- # Michal
- select kategorie.kategorie_nazwa, count(posty.posty_id) from kategorie
- left join posty on posty.kategorie_id=kategorie.kategorie_id
- group by kategorie.kategorie_nazwa
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement