[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