On Sun, 2003-01-19 at 10:44, Paul DuBois wrote: > At 7:18 +0000 1/19/03, Nasser Ossareh wrote: > > >a row gets inserted into this table > >whenever a visitor uses a certain tool on the site > > > >based on this approach your table does not have any entries for the > >days that no one uses the certain tool on the site. As a result > >your query can not pull out records which don't exist. > > > >You could catter for this programmatically by a perl script. The > >script could do this: > > That would work, but it's not necessary. He should use a LEFT JOIN, > which will produce a row in the output for the left table, whether > or not any right table rows match it. The syntax is in the MySQL manual. Well, the date is inserted into the master table only after a hit to the tool. Then, if in a date the tool is not called/used, then that date will not be in the master table. In this case a LEFT JOIN won't help. __ / \\ @ __ __ @ Adolfo Bello <[EMAIL PROTECTED]> / // // /\ / \\ // \ // Bello Ingenieria S.A. / ICQ: 65910258 / \\ // / \\/ // // / // cel: +58 416 609-6213 /___//// / <_/\__\\//__/ // fax: +58 212 952-6797 www.bisapi.com // pager: www.tun-tun.com (# 609-6213)
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php