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.