Question

  • Creator
    Topic
  • #2196841

    SQL help required.

    Locked

    by mckevitt ·

    could someone kindly help me out with the following.

    The following query works fine however i need to do the same thing only this time using an explicit join.

    select Departments.Deptnumber, Departments.name,
    sum (quantity)
    from SalesOrderItems, Departments
    where Departments.Deptnumber = SalesOrderItems.DeptNumber
    group by Departments.Deptnumber, Departments.name;

    I have tried

    select Departments.Deptnumber, Departments.name,
    sum (quantity)
    from Departments INNER JOIN SalesOrderItems
    ON Departments.Deptnumber = SalesOrderItems.DeptNumber
    order by Departments.Deptnumber, Departments.name;

    but keep getting the error
    ERROR at line 3:
    ORA-00933: SQL command not properly ended

    any help will be apriciated thanks.

All Answers

  • Author
    Replies
    • #3038915

      Clarifications

      by mckevitt ·

      In reply to SQL help required.

      Clarifications

    • #3038890

      Not properly ended means

      by robo_dev ·

      In reply to SQL help required.

      your ‘order by’ clause is not understood.

      What version Oracle?

      Joins are not supported in versions prior to 9i

    • #3038860

      Still need group by for sum operator

      by tony hopkinson ·

      In reply to SQL help required.

      select Departments.Deptnumber, Departments.name,
      sum (SalesOrderItems.Quantity)
      from Departments
      inner join SalesOrderItems
      On Departments.Deptnumber = SalesOrderItems.DeptNumber
      group by Departments.Deptnumber, Departments.name

      Group By should give you the ordering as well me thinks.

Viewing 2 reply threads