Joins in Crystal Reports

Hi,
I'm newbie in Crystal report. I've a query which i'm unable to implement in CR. Eventhough the query looks simple because of the join condition I'm struggling . Pls help me to implement the join condition. I run the query in DB2

select sum(bank_ledger_bal_amt),calendar_date
from table_a a
inner join table_date b
on a.bank_acct_eff_dt <= b.calendar_date
and a.bank_acct_disc_dt > b.calendar_date
where month_id = 'feb'
group by b.calendar_date
order by b.calendar_date
;

Thanks,
JashUse the add command of Crystal and paste in your SQL query in there.
GJ|||Sorry I didnt get what do you mean|||In the Database Expert there is an option to select "Add Command" there you can type out your sql. Crystal will let you know if there is an error in your SQL.
GJsql