Re: Date Query
Posted by:
Jay Balan
Date: October 10, 2006 10:54AM
If I just have this
FROM
users
WHERE
(users.hdsaliveexp <= date_sub(now(), interval -90 day))
I will get back 70 records if I do this
(users.hdsaliveexp < date_sub(now(), interval -90 day)) AND
(users.firstaidexp < date_sub(now(), interval -90 day))
It drops it down to 10 records as the second statement brings back only those records that match the where clause and also those that match the first statement.
I need to bring back all the records that match the first statement and also all the records for the second statement and so on
So if hdsaliveexp has 70 records and firstaidexp only has 3 I still need to see all 70 with dates and next column 3 with dates and so on
Subject
Written By
Posted
Re: Date Query
October 10, 2006 10:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.