Als resultaat krijg ik een lijst. Gerangschikt op week en jaar, maar ik krijg dubbele resultaten.quote:select DISTINCT(WEEKOFYEAR(FROM_UNIXTIME(date))) as WEEKNR , YEAR(FROM_UNIXTIME(date)) AS year from tbl1
union
select DISTINCT(WEEKOFYEAR(FROM_UNIXTIME(date))) as WEEKNR , YEAR(FROM_UNIXTIME(date)) AS year from tbl2
union
select DISTINCT(WEEKOFYEAR(FROM_UNIXTIME(date))) as WEEKNR , YEAR(FROM_UNIXTIME(date)) AS year from tbl3
order by date desc
1 2 3 4 5 6 7 | FROM ( SELECT foo FROM bar1 UNION ALL SELECT foo FROM bar2 ) bar ORDER BY foo |
|
Forum Opties | |
---|---|
Forumhop: | |
Hop naar: |