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?
thanks :)