SQL Query Help: Joining on where IN

• eric.breckenridge

  Grasshopper

  Points: 20

  More actions

  May 26, 2018 at 6:33 am

  #351743

  Easier to demo than explain. Excuse the format, this is my first post.

  Is it possible to join on a partial match? See below. If i join on like '% + i.equipmentid + %' then i get I could join on 1234567 as well, which is an issue. 

  equipment.equipment id - 123456
  Invoice.equipmentid - 123456, 234567,3454678,1234567

  Thanks in advance.

• SGT_squeequal

  SSCertifiable

  Points: 7167

  More actions

  May 26, 2018 at 7:51 am

  #1992053

  it would be easier to help if we knew what the data looked like, can you provide DDL to create representative data?

  ***The first step is always the hardest *******

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  May 26, 2018 at 8:14 am

  #1992054

  eric.breckenridge - Saturday, May 26, 2018 6:33 AM

  Easier to demo than explain. Excuse the format, this is my first post.

  Is it possible to join on a partial match? See below. If i join on like '% + i.equipmentid + %' then i get I could join on 1234567 as well, which is an issue. 

  equipment.equipment id - 123456
  Invoice.equipmentid - 123456, 234567,3454678,1234567

  Thanks in advance.

  It would probably be easier (and faster) for you to use a string splitter on your Invoice.equipmentid column and then to match on the split results.
  Here is a link to one of the best splitters around.

  ---