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

    Join Date
    May 2011
    Posts
    1
    Rep Power
    0

    Can any one look at my easy code?


    Hello,

    Can any one look at this code and corect it?

    select res.code_art,sum (no_pers)
    from res r, arts a
    where res.code_art=arts.code_art
    group by res.kod_art, res.date_art
    having sum (no_pers)>...........;

    ................. I want put here max_person from arts
  2. #2
  3. Humble Learner
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2007
    Location
    Bangalore, India
    Posts
    280
    Rep Power
    120
    kindly post your table structure .

    Why are you using table name in the query even though you have mentioned alias for the same.

IMN logo majestic logo threadwatch logo seochat tools logo