my first list id interestId 1 1,2,3,4 2 2,3,4,5 3 1,2,3,45 4 2,3,4,5 my second list interestId 1 2 3 4 So how to get second table interestId column with first table using linq query? Any one have a idea?