Index: openacs-4/packages/lab-report/www/view-lab-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lab-report/www/view-lab-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lab-report/www/view-lab-postgresql.xql	11 May 2006 11:11:37 -0000	1.1
+++ openacs-4/packages/lab-report/www/view-lab-postgresql.xql	12 May 2006 01:34:34 -0000	1.2
@@ -16,9 +16,11 @@
 
    <fullquery name="select_reports">
      <querytext>
-       SELECT t.template_id, t.name,
+       SELECT r.report_id, t.template_id, t.name,
            t.description AS template_desc
-       FROM lrc_template t, lrc_lab_template_map m
+       FROM lrc_template t
+           LEFT OUTER JOIN lr_report r ON (r.template_id = t.template_id),
+           lrc_lab_template_map m
        WHERE m.lab_id = :lab_id
        AND m.template_id = t.template_id
      </querytext>