Catalog: alle courses die onder een bepaalde categorie staan

posted on Aug 25, 2006 by in Queries

pk1_gateway_categories moet je zelf invullen, deze kan je zien in de url.

select cm.pk1
,      cm.course_name
from bb_bb60.gateway_course_categories gcg
,    (select gc.pk1
      from bb_bb60.gateway_categories gc
      start with gc.pk1 = <pk1_gateway_categories>
      connect by prior gc.pk1 = gc.gatewaycat_pk1
     ) gc1
,    bb_bb60.course_main cm
where gc1.pk1 = gcg.gatewaycat_pk1
and cm.pk1 = gcg.crsmain_pk1
order by cm.course_name

No feedback yet

Form is loading...