Re:

Deenadhayalan Subramani said: > > Any better ways to re write this query . > > > > > > SELECT > > ch.ch_rec_key, > > ch.ch_ctry_hol_lk, > > ch.cal_calendar_dt, > > co.co_ctry_cd, > > op.op_type_cd, > > ch.ch_name, > > ch.ch_remarks, > > ch.ch_rec_effect_dt, > > ch.ch_rec_expiry_dt, > > ch.ch_chg_timestamp > > FROM > > country_holiday ch, country co, op_type op > > WHERE > > ch.op_type_lk = op.op_type_lk AND > > ch.co_ctry_lk = co.co_ctry_lk AND > > co.co_ctry_cd = ? AND > > ch.cal_calendar_dt = ? > > > > AND > > > > ( ( ch.ch_rec_effect_dt <= ? AND > > ch.ch_rec_expiry_dt >= ? ) OR > > ( ch.ch_rec_effect_dt <= ? AND > > ch.ch_rec_expiry_dt is null ) ) > > > > AND > > > > ( ( co.co_rec_effect_dt <= ? AND > > co.co_rec_expiry_dt >= ? ) OR > > ( co.co_rec_effect_dt <= ? AND > > co.co_rec_expiry_dt is null ) ) > > > > AND > > > > ( ( op.op_rec_effect_dt <= ? AND > > op.op_rec_expiry_dt >= ? ) OR > > ( op.op_rec_effect_dt <= ? AND > > op.op_rec_expiry_dt is null ) ) Yes. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list