Re: Query Help

Try this:

1) Remove DISTINCT ON(item.description)
2) Add "GROUP BY item.description"
3) Add (after SELECT) "count(pack_num),"

--- Joe Koenig <joe(at)jwebmedia(dot)com> wrote:
> I have an existing query to pull some product info from my db - there
> is
> a field, item.pack_num, that tells whether the item is new (1) or
> used
> (2). When I display the listing to the web users, I want to be able
> to
> tell them if a used item is available for each item in the list.
> However, I want this to all be done with 1 query - so what I'm
> wondering
> is, is there a way to modify my exising query (below) to have it give
> the the item with the pack_num of 2, if there are new and used items
> in
> the db. The DISTINCT ON(item.description) is there because if there
> is a
> new and used item, the item is listed in the db twice, once for each
> pack_num (I know, bad layout - not my idea...). I don't want the
> query
<SNIP>

=====
Chris Albertson
Home: 310-376-1029 chrisalbertson90278(at)yahoo(dot)com
Cell: 310-990-7550
Office: 310-336-5189 Christopher(dot)J(dot)Albertson(at)aero(dot)org

__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com