Results 1 to 6 of 6

Thread: sorting problem

  1. #1
    Join Date
    Dec 2003
    Location
    Athens,GR
    Posts
    16

    Unhappy Unanswered: sorting problem

    i want to modify this table:
    employees----address----phone1----phone2----phone 3
    ----------------------------------------------------------------
    John A. keas 19 9515678
    John A. keas 19 9515670
    Mike B. highway 2 8652332
    Mike B. highway 2 8656543
    Mike B. highway 2 8723165

    like this :
    employees----address----phone1----phone2----phone 3
    ----------------------------------------------------------------
    John A. keas 19 9515678 9515670
    Mike B. highway 2 8652332 8656543 8723165

    _________________________________________________
    may seem silly,i know,but i am stuck here days now and i dont know with what to fill my loop.
    thank you in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: sorting problem

    The answer is DBMS-specific. What DBMS are you using?

  3. #3
    Join Date
    Dec 2003
    Location
    Athens,GR
    Posts
    16

    Re: sorting problem

    it is VB using sql

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: sorting problem

    "SQL" is the query language used by various DBMSs including Oracle, Microsoft SQL Server, DB2, mySQL... Which DBMS are you using?

  5. #5
    Join Date
    Dec 2003
    Location
    Athens,GR
    Posts
    16
    Microsoft SQL Server

  6. #6
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Originally posted by piulibero
    Microsoft SQL Server
    OK, I'll move you to the right forum. Please note that "SQL" and "SQL Server" are not the same thing!

Posting Permissions

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