Results 1 to 2 of 2

Thread: Oracle Error

  1. #1
    Join Date
    Jan 2011
    Posts
    1

    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

  2. #2
    Join Date
    Feb 2011
    Posts
    1

    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
  •