Mahesh Ishwar wrote:

> and not exists (select column4
> from table1
> where column3 < current_date
> and column3 > current_date
> and column5 <> 'XYZ'
> )
>
> Please let me know in case is something else you want to know.

Hm, this doesn't look right. Can you please post the ORIGINAL query
you're using, since column3 < current_date and column3 > current_date
doesn't make any sense. The inner query wouldn't return any rows.

--
Milan Babuskov
http://fbexport.sourceforge.net