How to show multiple values in my column of my join query ?

• raghuldrag

  Hall of Fame

  Points: 3160

  More actions

  November 6, 2014 at 2:28 am

  #312702

  Hi Friends,

  Hi Friends ,

  in my table i ve the column of item code which contains '1000' ,'2000' ,'3000' series i jus wanna display the output of item codes '1000','2000'series and some of ('3000019','3000020','3000077','3000078').

  i tried in my join query

  these code left(itemcode,4) in ('1000','2000') or itemcode in ('3000019','3000020','3000077','3000078')

  its taking so much of time how t o solve ?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 6, 2014 at 2:47 am

  #1756910

  Lots of information missing from your post. See the first article linked in my signature line for posting guidelines.

  One of your predicates is not SARGable:

  left(itemcode,4) in ('1000','2000') or itemcode in ('3000019','3000020','3000077','3000078')

  try changing it to this:

  itemcode LIKE '1000%'

  OR itemcode LIKE '2000%'

  OR itemcode in ('3000019','3000020','3000077','3000078')

  -- Gianluca Sartori