SELECT P.ProductID,
		   P.Name,
		   P.ProductNumber,
		   P.FinishedGoodsFlag,
		   P.ListPrice
	FROM   AdventureWorks2016.Production.Product P
	WHERE  P.SellEndDate is NULL
		   AND P.DiscontinuedDate is NULL
		   AND EXISTS (SELECT 1
					   FROM  AdventureWorks2016.Production.BillOfMaterials BOM
					   WHERE P.ProductID = BOM.ComponentID
					  )