mySQL vs PostgreSQL exception join example

except.sql

/* All product subcategory IDs
 * for non bicycle frame items
 * mySQL example using WHERE / NOT IN
 */
SELECT p.Name, p.Color, p.ProductSubcategoryID
FROM Product p 
LEFT JOIN ProductSubcategory ps on ps.ProductSubcategoryID = p.ProductSubcategoryID
WHERE ps.ProductSubcategoryID NOT IN
	(SELECT ProductSubcategoryID FROM ProductSubcategory WHERE Name LIKE '%Frame%')
  
/* All product subcategory IDs
 * for non bicycle frame items
 * postgres example using except
 */
SELECT p.ProductSubcategoryID
FROM Product p 
LEFT JOIN ProductSubcategory ps on ps.ProductSubcategoryID = p.ProductSubcategoryID
EXCEPT ps.ProductSubcategoryID IN
	(SELECT ProductSubcategoryID FROM ProductSubcategory WHERE Name LIKE '%Frame%')