sql - Check if value is in different table -

so new sql , have little experience it. please excuse if basic can't seem find after googling...

so have table contains serialnumber field. have single inputfield contains comma seperated values each 1 being serialnumber. want display serialnumbers in comma seperated string.

so have splitstring function can use splits string @ commas this:

select * dbo.splitstring('sn1,sn2,sn3,sn4,sn5,sn6', ',') 

this returns table each sn being row.

so want this:

select     *     tbl_serials sn     sn.serialnumber in dbo.splitstring('sn1,sn2,sn3,sn4,sn5,sn6', ',') 

so display rows serialnumber inside string. don't know how syntactily construct this.

any appreciated

one method using join:

select sn.* tbl_serials sn join      dbo.splitstring('sn1,sn2,sn3,sn4,sn5,sn6', ',') ss(val)      on sn.serialnumber = ss.val; 

with route, need subquery:

select sn.* tbl_serials sn join sn.serialnumber in (select val                           dbo.splitstring('sn1,sn2,sn3,sn4,sn5,sn6', ',') ss(val)                          ); 

in both these cases, as ss(val) assigns table alias and column alias value. versions of splitstring might return more 1 value (such position). if have such version, need include return values named columns.