Record Selection

• ROCKO

  Old Hand

  Points: 399

  More actions

  May 23, 2003 at 8:47 am

  #160118

  If you have a main file used as your driver

  how do you keep the selection of only those records wehn matching to other files ?

  The file I am matching with has multiple matches so it give me more than one unique record from my driver file.

• May 26, 2003 at 8:00 am

  This was removed by the editor as SPAM

• David Burrows

  SSC Guru

  Points: 65111

  More actions

  May 27, 2003 at 3:05 am

  #458587

  Could use

  select distinct m.cola,m.colb from maintable m

  inner join othertable x on x.key = m.key

  or

  select m.cola,m.colb from maintable m

  inner join (select distinct key from othertable) x on x.key = m.key

  Far away is close at hand in the images of elsewhere.
  Anon.