» Poradna » Programy

Access - sjednocovací dotaz,nefunguje ,poradí někdo?

 |   | 

SELECT TEAM,Sum(Nz([YRS],0)) as TYRS
FROM POH
WHERE [POCODE] = "SPHL"
GROUP BY TEAM
UNION SELECT TEAM1,Sum(Nz([YRS1],0))
FROM POH1
WHERE [POCODE] = "SPHL"
GROUP BY TEAM1;

Mohlo by vás také zajímat


Související témata: Team, Group, From, Union