[thelist] help w/design of SQL query

Alex Ezell taranis at spittingllamas.com
Thu Nov 14 17:40:00 CST 2002


On Thu, 14 Nov 2002 18:24:41 -0500, rudy <r937 at interlog.com> wrote:

> select catname, itemname
> from items, cats
> where items.catid = cats.id
> order by catname, itemname

Not to confuse matters, but remember that the GROUP BY clause might come in
handy.
You can't use it to get the results you want (i.e. the item names), but if
you wanted to count how many items were in each category or something like
that, it would be nice.
--
Alex Ezell
http://www.spittingllamas.com
"Formal Restrictions, contrary to what you might think, free you up by allowing
 you to concentrate on purer ideas."
- Winter Sorbeck in Chip Kidd's The Cheese Monkeys



More information about the thelist mailing list