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

Options: ReplyQuote


Subject
Written By
Posted
October 06, 2006 02:00PM
October 06, 2006 06:44PM
October 10, 2006 09:37AM
October 10, 2006 09:58AM
Re: Date Query
October 10, 2006 10:54AM
October 10, 2006 11:12AM
October 10, 2006 11:17AM
October 10, 2006 11:28AM
October 10, 2006 11:44AM
October 10, 2006 11:57AM
October 12, 2006 08:46AM
October 13, 2006 09:59AM


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.