multiple rows joined on different columns

• Mike Coffey

  Newbie

  Points: 3

  More actions

  December 3, 2005 at 9:54 am

  #88824

  does anyone know how to select (delete) the second of a pair of rows in 1 table that are joined by 2 different columns and ordered by a third?

  e.g. row 1 = a, today, x, y

  row 2 = b, yesterday, z, x

   

  I want to select row 2 (and do that for many millions of other pairs)

• Charles Otten

  Default port

  Points: 1475

  More actions

  December 3, 2005 at 12:09 pm

  #607576

  I'm not sure I'm following your question.  Can you post a few rows and show the select statement? 

  If the phone doesn't ring...It's me.

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  December 3, 2005 at 2:42 pm

  #607583

  Please provide DDL and sample data.

  For an explanation, see http://www.aspfaq.com/etiquette.asp?id=5006

  SQL = Scarcely Qualifies as a Language