[PHP3] Question for Oracle Guru's From: Josh G (josh <email protected>)
Date: 02/29/00

Hi, I have a query, that works as it is:

SELECT parent.category_id as p_id, parent.name as p_name, child.category_id as c_id, child.name as c_name, DECODE(count(item.category_id),NULL,0,count(item.category_id)) as item_count FROM mall_category parent, mall_category child, mall_item item WHERE parent.category_id = child.parent_id and item.category_id (+) = child.category_id and item.hidden=0 GROUP BY parent.name, parent.category_id, child.category_id , child.name order by parent.name, child.name

Buuuuuuut, I want to get duplicates of child.name, which Oracle won't let me do.
Is there a simple way to get around this? It complains when I leave out child.name
from the group by.

Cheers,
-Josh

------------------------------------------------------------------------------------
I gotta go coz I got me a drop-top and
If I hit the switch, I can make that ass drop