Hm
Mozda mislis ovo;
SELECT poruke.id,poruke.poruk,
sum(CASE Statusi.id WHEN 1 THEN 1 ELSE 0 END) AS Status_1,
sum(CASE Statusi.id WHEN 2 THEN 1 ELSE 0 END) AS Status_2,
sum(CASE Statusi.id WHEN 3 THEN 1 ELSE 0 END) AS Status_3
FROM PorukaStatus INNER JOIN
poruke ON PorukaStatus.id_poruke = poruke.id INNER JOIN
statusi ON PorukaStatus.id_status = statusi.id
GROUP BY poruke.id,poruke.poruk
GO
|