Select rows from a table where row in another table with same id has a particular value in another colum
Select rows from a table where row in another table with same id has a particular value in another column