Originally posted by hausl78
View Post
[highlight=sql]
...
SELECT itipps.Nickname, itipps.Punkte
FROM tab_tipps itipps
inner join tab_spiele ispiele on ispiele. ...
and DATE(ispiele.Beginn) = CURDATE()
UNION ALL
SELECT izwtipps.Nickname, izwtipps.Punkte
FROM tab_zw_tipps izwtipps
inner join tab_zw izw on izw. ...
and DATE(izw.Beginn) = CURDATE()) t
...
[/highlight]
Gruß Falk
Comment