I have a table with 3 columns- Project, Description and Platforms.

I have another table with 1 column - Platform.
I select the data from the 2nd table. When I click on an item, how can I get the Project and Description from the first table.

Data in First Table-Column Platforms:
1st row: One, Two, Three, Four
2nd row: Two, Four, Six
3rd row: One, Three, Five

Data in Second Table-Column Platform:
One
Two
Three
Four
Five
Six

So When we click on 'One', it should return the 1st and 3rd rows from the 1st table.

Thank u.

hi, try this

SELECT A.*
FROM TableA A INNER JOIN Table B ON ',' + A.Platforms + ',' LIKE '%,' + B.Platform + ',%'
WHERE B.Platform='One'