« Users: aantal unieke gebruikers per dag
Portfolio: aantal items per portfolio »

Catalog: alle courses die onder een bepaalde categorie staan

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
Queries
 Print article This entry was posted by admin on 25 August 2006 at 15:03:04 . Follow any responses to this post through RSS 2.0.
No feedback yet
Comments are closed for this post.
Trackback address for this post
This is a captcha-picture. It is used to prevent mass-access by robots.
Please enter the characters from the image above. (case insensitive)