I am using SQL2000 with Crystal report 9

Is there a way to add condition in the left outer join sth like:

Select tbl1.number , tbl1.desc, sum(tbl2.amount)   from tbl1 left outer join tbl2 on tbl1.number=tbl2.number and tbl2.ldate <= ‘2009/12/31’

Tbl1

1                     aaa

2                     bbb               

3                     ccc

Tbl2

1              5000      2009/06/06

1              1000       2008/12/31

1              6000       2008/11/11

Result must be

1          aaa 7000

2         Bbb 0

3         Ccc 0

I cannot add the condition in the Database expert (tbl2.ldate <= ‘2009/12/31’) is there a way to do that?

My two cents....