phpbar.de logo

Mailinglisten-Archive

=?ISO-8859-1?Q?Re:_tabellen_verkn=FCpfen?=

Re: tabellen verknüpfen

Ralf Eggert mysql_(at)_lists.phpcenter.de
Wed, 27 Jun 2001 17:51:55 +0100


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 



php::bar PHP Wiki   -   Listenarchive