SQL question regarding a couple of table joins.

Greetings.

We three have three tables, a links table which stores basic information
about a link, a linksdetail table which stores more detailed information
about the link, and a linkdaystats table which records the daily statistical
information on the link.

My problem is, once a day I want to delete everything in that table to start
afresh.  Any information accumulated in the linkdaystats table has been
parsed, multilated, spindled, whatever, and done with, do I merely do a
'drop from linkdaystats' to start afresh.  The only issue is this causes
other queries to break, suck as the only below :

SELECT
            links.linkid,
                       links.linkurl,links.linktext,links.bannerid,linkdaystats.linkid
 
FROM   links, linkdetail ,   linkdaystats
WHERE     links.linkid = linkdetail.linkid                                     

----linkid | linkurl | linktext | bannerid | linkid 
--------+---------+----------+----------+--------
(0 rows)
----

Help?  :)  This is PostGreSQL 7.0.2 on Debian 2.2/Linux-2.2.17 (Kernel/PGSQL
from source)

--- Table information :

freehost=# \d links                                Table "links"Attribute |     Type     |
Modifier                     
 
-----------+--------------+----------------------------------------------------linkid    | integer      | not null
defaultnextval('links_linkid_seq'::text)linkurl   | varchar(255) | linktext  | varchar(255) | bannerid  | integer
|
 
Index: links_linkid_key

freehost=# \d linkdetail            Table "linkdetail"    Attribute     |     Type     | Modifier 
-------------------+--------------+----------linkid            | integer      | referrer          | varchar(255) |
maxclicks        | integer      | maximpressions    | integer      | primarycategory   | integer      |
secondarycategory| integer      | tertiarycategory  | integer      | weight            | float4       | starttime
 | timestamp    | stoptime          | timestamp    | 
 

freehost=# \d linkdaystats       Table "linkdaystats" Attribute  |   Type    | Modifier 
-------------+-----------+----------linkid      | integer   | datestamp   | timestamp | clicks      | bigint    |
impressions| bigint    | 
 


Sincerely, Warren