Predmet:Re: MySql Tabela lige
Ako sam tacno nabo polja odnosno razumio onda tebi treba ovo.
PreuzmiIzvorni kôd (Text):SELECT t.naziv, sum( u.gold ) AS gol, sum( u.bodd ) AS bod, "Kod kue" AS d_g
FROM `man_utakmice` AS u
LEFT JOIN man_timovi AS t ON t.id = u.domacin
WHERE u.liga_id =1
GROUP BY domacin
UNION
SELECT t.naziv, sum( u.golg ) AS gol, sum( u.bodg ) AS bod, "U gostima" AS d_g
FROM `man_utakmice` AS u
LEFT JOIN man_timovi AS t ON t.id = u.gost
WHERE u.liga_id =1
GROUP BY gost
ORDER BY `naziv`
Podrška samo putem foruma, jer samo tako i ostali imaju koristi od toga.
Ovaj post je ureden
1
puta. Posljednja izmjena 27.08.2016 11:06 od strane Avko.