From 4e6f299d3534db4f057b71af92debfcbfb9663bd Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Thu, 1 Feb 2001 19:13:47 +0000
Subject: [PATCH] A patch for the GROUP BY/HAVING example.  p.date should be
 s.date.

Robert B. Easter
---
 doc/src/sgml/queries.sgml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml
index 0cbaa16c55..6e35789eca 100644
--- a/doc/src/sgml/queries.sgml
+++ b/doc/src/sgml/queries.sgml
@@ -531,7 +531,7 @@ SELECT pid    AS "Products",
        p.name AS "Over 5000",
        (sum(s.units) * (p.price - p.cost)) AS "Past Month Profit"
   FROM products p LEFT JOIN sales s USING ( pid )
-  WHERE p.date > CURRENT_DATE - INTERVAL '4 weeks'
+  WHERE s.date > CURRENT_DATE - INTERVAL '4 weeks'
   GROUP BY pid, p.name, p.price, p.cost
     HAVING p.price > 5000;
 </programlisting>
-- 
2.39.5