select DB2 Query

[srini06]

I am very newer to database.
I am having the situation like I am having 5 felds in my sorce database Table T1 for exaple :
T1 fileds :date1,date2,Sex,Name,Id

I want to load it into some target table T2 by selecting the rows based on two conditions.

1.last 3 days records based on date1 or date2 after selecting these records I wan to select it
with sex filed 'Male'.I am having little knowledge of database the quesry look like this

select * from T1 where (sysdate >= (date1+3) or (date2+3))Now i wan to filter records by checking
Sex flag 'Male'can you help me on that.Thanks in advance.

[kalexin]

I am very newer to database.
I am having the situation like I am having 5 felds in my sorce database Table T1 for exaple :
T1 fileds :date1,date2,Sex,Name,Id

I want to load it into some target table T2 by selecting the rows based on two conditions.

1.last 3 days records based on date1 or date2 after selecting these records I wan to select it
with sex filed 'Male'.I am having little knowledge of database the quesry look like this

select * from T1 where (sysdate >= (date1+3) or (date2+3))Now i wan to filter records by checking
Sex flag 'Male'can you help me on that.Thanks in advance.

select * from T1 where (sysdate >= (date1+3) or (date2+3))
AND SEX = 'MALE';