-
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
-
syntax issue
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|