#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2008
    Posts
    1
    Rep Power
    0

    Question Select Query From Multiple Table


    Please Help Me In Following Query....i Am Using Oracle 9i In Visual Basic 2005.

    Select H.initial_ladle_wt,sum(s.slab_weight),count(s.slab_weight) From Heat_report H,slab_report S Where H.heat_no = 'c51969'

    But I Will Give Following Error

    Ora-00937 Not A Single-group Group Function
  2. #2
  3. Lord of the Dance
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Oct 2003
    Posts
    4,206
    Rep Power
    2012
    did you tried a search at google?
    first page in result gave this:

    btw, shouldn't there be a relation between heat_report and slab_report?

IMN logo majestic logo threadwatch logo seochat tools logo