|
1 | | -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/queries.sgml,v 1.1 2001/01/22 23:34:33 petere Exp $ --> |
| 1 | +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/queries.sgml,v 1.2 2001/02/01 19:13:47 momjian Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="queries"> |
4 | 4 | <title>Queries</title> |
@@ -531,7 +531,7 @@ SELECT pid AS "Products", |
531 | 531 | p.name AS "Over 5000", |
532 | 532 | (sum(s.units) * (p.price - p.cost)) AS "Past Month Profit" |
533 | 533 | FROM products p LEFT JOIN sales s USING ( pid ) |
534 | | - WHEREp.date > CURRENT_DATE - INTERVAL '4 weeks' |
| 534 | + WHEREs.date > CURRENT_DATE - INTERVAL '4 weeks' |
535 | 535 | GROUP BY pid, p.name, p.price, p.cost |
536 | 536 | HAVING p.price > 5000; |
537 | 537 | </programlisting> |
|