Update Advanced SQL Puzzles Solutions.sql

smpetersgithub · web-flow · commit a69c9ef32286 · 2024-06-10T14:45:00.000-05:00
diff --git a/Advanced SQL Puzzles/Advanced SQL Puzzles Solutions.sql b/Advanced SQL Puzzles/Advanced SQL Puzzles Solutions.sql
@@ -2985,7 +2985,7 @@ FROM    #ProductsA a FULL OUTER JOIN
 SELECT  'Matches in both table A and table B' AS [Type],
         ProductNameA
 FROM    cte_FullOuter
-WHERE   ProductNameA = ProductNameB
+WHERE   ProductNameA = ProductNameB AND QuantityA = QuantityB
 UNION
 SELECT  'Product does not exist in table B' AS [Type],
         ProductNameA
@@ -3000,7 +3000,7 @@ UNION
 SELECT  'Quantities in table A and table B do not match' AS [Type],
         ProductNameA
 FROM    cte_FullOuter
-WHERE   QuantityA <> QuantityB;
+WHERE   ProductNameA = ProductNameB AND QuantityA <> QuantityB;
 GO
 
 /*----------------------------------------------------
