Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Location
    Netherlands
    Posts
    98

    Question Unanswered: Need help with group query

    Hi all,

    I have 2 tables 1 is called Phonebrands the other is called phonetypes
    is it possible to show all the phonetypes gouped by the phone brand?

    Cheers Wim

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, except "grouped" is the wrong word -- what you are thinking of is ORDER BY
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2003
    Location
    Netherlands
    Posts
    98
    Quote Originally Posted by r937
    yes, except "grouped" is the wrong word -- what you are thinking of is ORDER BY
    Ok but now i want 2 show like this

    Nokia
    1. 6230
    2. 6600
    3. 7300


    Siemens
    1. SomePhone
    2. Somephone2



    etc etc

    So how can i do this?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Wimmo
    So how can i do this?
    in your application layer (i.e. not with sql)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Oct 2003
    Location
    Netherlands
    Posts
    98
    Quote Originally Posted by r937
    in your application layer (i.e. not with sql)
    So only in the application not in sql,
    Thank you for your help and time!

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Not so much because this CAN'T be done in SQL (it can), but because it SHOULDN'T be done in SQL.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •