Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008
    Posts
    35

    Unanswered: Self Join Query - Help

    I'm trying to do a self join but getting a cross join.

    Table Structure :- Col2 is date

    Col1 Col2 Col3 Col4
    1 02/02/2009 2.5 1
    1 02/02/2009 2.6 5
    1 02/02/2009 2.7 10
    1 02/03/2009 3.6 1
    1 02/03/2009 3.7 5
    1 02/03/2009 3.8 10


    I need to show the results in this manner.

    Col1 Col2 Col3 Col1 Col2 Col3
    1 02/02/2009 2.5 1 02/03/2009 3.6

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    What SQL have you done so far?

Posting Permissions

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