The following SQL code is a Subquery Rewrite it as a JOIN an

The following SQL code is a Subquery. Rewrite it as a JOIN and no Subquery. SELECT FS_NO, NAME FROM S WHERE FS_NO IN (SELECT FS_NO FROM SH WHERE HNO = \'HI\' OR HNO = \'H2\'); Find the name and number of (fire) staff who have every skill.

Solution

The SQL query using Join

SELECT S.FS_NO, S.Name
FROM Orders
INNER JOIN SH
ON Orders.CustomerID=Customers.CustomerID where SH.HNO=\'H1\' OR SH.HNO=\'H2\';