Oracle Error

I'm getting the following error when I run the SQL below...

37000(907)[Microsoft][ODBC driver for Oracle][Oracle]ORA-00907: missing right parenthesis (0.09 secs)

Can someone offer some insight?... I don't see what's wrong.

Thanks


Select d.deposit_id, d.deposit_dt, d.expected_deposit_amt,
i.deposit_id, i.deposit_item_dt, i.deposit_item_amt
from st.deposit d

full join

(select i.deposit_id, i.deposit_item_dt, sum(i.deposit_item_amt)
from st.deposit_item i
group by i.deposit_id i.deposit_item_dt)

on d.deposit_id = i.deposit_id

try putting an alias after the brackets which contain the select with the sum. Then use that alias instead of the "i" in the i.deposit in the "ON" clause.