problem in select statement

• prakash.ss83

  SSC Enthusiast

  Points: 143

  More actions

  March 4, 2010 at 5:22 am

  #143383

  hi,

  There is a table mmproductstyle contains details about partno and style number.

  EG:--style number as 34,68,70

  These styles are assigned to partno.

  partno stylenumbers

  ------ ----------

  100400916

  300342934

  100451668

  300219221

  100468516

  300342968

  100451634

  I need to get the partno which contains both stylenumbers 34 and 68

  The results must be

  3003429

  1004516

  Regards,

  Prakash

• SQL Editor

  SSCommitted

  Points: 1980

  More actions

  March 4, 2010 at 5:46 am

  #1128420

  select partno from table3 where style='34'

  intersect

  select partno from table3 where stylenumbers='68'

• prakash.ss83

  SSC Enthusiast

  Points: 143

  More actions

  March 4, 2010 at 6:09 am

  #1128448

  hi,

  I used it but its not working.

  Regards,

  PRakash