On Mon, 20 Jun 2005 18:44:08 +0300, Sudheer Palaparambil
<sudheer.clt@...> wrote:

> SELECT ST.sale_type_nm, MIN( SL.bill_no ), MAX( SL.bill_no )
> FROM sale_type ST LEFT JOIN sale SL ON ( ST.company_id =
> SL.company_id )
> AND ( ST.id = SL.s_type )
> WHERE ( SL.entry_date BETWEEN '2.5.05' AND '2.5.05' )

You must add

'OR SL.entry_date IS NULL'

to your WHERE clause.

Cheers,
--
Miroslav Penchev