多表查询列表单元

   对列表中的SQL语句做一下设置：select t1.tr_name ,t2.* from CCII_TRAINORG t1 left join CCII_TRAINORG_TEACHER  t2  on t1.trid = t2.trid where 1=1  $Q{CCII_TRAINORG,t1} $Q{CCII_TRAINORG_TEACHER, t2}

   对应解释为：select t1.tr_name ,t2.* from CCII_TRAINORG t1 left join CCII_TRAINORG_TEACHER  t2  on t1.trid = t2.trid where 1=1 and t1.key1 = value1 and t2.key2 = value2

列表单元中的列表项多表联合查询和显示。