Re: Can anyone suggest a more efficient method

2001-02-12 Thread Rus
I am not shure about recalculating constants in mysql. Try . where activity.event_time_unix <= const .. where const is the result of 981990589 - (2* ( 24 * (60 * 60) ) ) - Original Message - From: Bryan Hunt <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, F

RE: Can anyone suggest a more efficient method

2001-02-12 Thread Johnson, Gregert
SELECT unit.* FROM unit LEFT JOIN activity ON unit.dialup_user = activity.dialup_user AND !(activity.event_time_unix ...) AND unit.status = 'Active' WHERE activity.dialup_user IS NULL; --Greg Johnson -Original Message- F