t;
Sent: Monday, February 12, 2001 7:09 PM
Subject: Can anyone suggest a more efficient method
> I have two tables, one contains units one contains activity
> I run this query ..
>
> select unit.dialup_user, unit.address1, activity.dialup_user
> from unit
> LEFT JOI
al Message-
From: Bryan Hunt [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 11:10 AM
To: [EMAIL PROTECTED]
Subject: Can anyone suggest a more efficient method
I have two tables, one contains units one contain
I have two tables, one contains units one contains activity
I run this query ..
select unit.dialup_user, unit.address1, activity.dialup_user
from unit
LEFT JOIN activity ON
(unit.dialup_user = activity.dialup_user)
where !(activity.event_time_unix > (981990589 - (2* ( 24 * (60 *
60) )
