Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    74

    Unanswered: Merge data in two rows into one row

    Hi!

    I have data in the following manner:

    period course1 course2
    4 NULL Eng
    4 NULL Math
    4 Phys NULL
    4 Chem NULL

    Is there any way I can show this data this way (the order is irrelevant - row1 can be joined with row3 or row4)?
    period course1 course2
    4 Phys Eng
    4 Chem Math
    4 Phys Eng
    4 Chem Math

    Basically, I want to be able to remove nulls.

    Please let me know if any of you have come across such an issue.

    Thanks so much!

    -Parul
    Last edited by ParulV; 12-06-06 at 02:13. Reason: stating the problem more appropriately

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    how r u linking these rows? on what logic? for example why row1 and row3 are joined together and why not row1 and row4?

    check the recent post
    http://www.dbforums.com/showthread.php?t=1612226
    which is somewhat similar to your problem and not yet concluded........

  3. #3
    Join Date
    Oct 2002
    Posts
    74
    Thanks, Upalsen.

    I restated the problem... please see if this makes it clearer?

    Thanks!
    Parul

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    sorry, not clearer
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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