Index: openacs.org-dev/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql,v
diff -u -r1.1.1.1 -r1.1.1.2
--- openacs.org-dev/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql 9 Jul 2002 17:35:05 -0000 1.1.1.1
+++ openacs.org-dev/packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql 8 Oct 2002 15:47:06 -0000 1.1.1.2
@@ -7,6 +7,14 @@
8.1.6
+
+
+ select c.category_id, s.subcategory_id, category_name, subcategory_name
+ from ec_categories c, ec_subcategories s
+ where c.category_id(+)=s.category_id
+
+
+
sysdate