Re: tabellen verknüpfen

[Ralf Eggert]

Hi Andreas,

versuch es mal mit einem Left Join.

  SELECT DATE_FORMAT(pageviews_archiv.day, '%Y-%m-%d')as datold2,
         sum(pageviews_archiv.count) as piold2,
         sum(pageviews_archiv.visits) as viold2, 
         pageviews_archiv_ivw.countivw as piivwold2,
         pageviews_archiv_ivw.visitsivw as viivwold2 
  FROM pageviews_archiv
  LEFT JOIN pageviews_archiv_ivw 
  ON pageviews_archiv.day = pageviews_archiv_ivw.day
  WHERE MONTH(pageviews_archiv.day) = MONTH(CURDATE())- 2 
  AND YEAR(pageviews_archiv.day) = YEAR(CURDATE()) 
  GROUP BY pageviews_archiv.day
  ORDER BY pageviews_archiv.day

Gruss,

        Ralf

---
!!NEU!!
Fragen und Antworten zu MySQL und dieser Liste unter
-->>  http://www.4t2.com/mysql