三个表tr_hist, pt_mstr, pl_mstrtr_hist和表pt_mstr的关键字是tr_hist.tr_part=pt_mstr.pt_part,pt_mstr和pl_mstr的关键字是pt_mstr.pt_prod_line=pl_mstr.pl_prod_line我把三表的一些字段放一个报表里,报表的profile中的SQL显示select T1.tr_part, T1.tr_qty_chg, T2.p...
显示全部三个表tr_hist, pt_mstr, pl_mstr
tr_hist和表pt_mstr的关键字是tr_hist.tr_part=pt_mstr.pt_part,
pt_mstr和pl_mstr的关键字是pt_mstr.pt_prod_line=pl_mstr.pl_prod_line
我把三表的一些字段放一个报表里,报表的profile中的SQL显示
select T1.tr_part, T1.tr_qty_chg, T2.pt_desc1, T2.pt_prod_line
from {oj mfgtrain.tr_hist T1 LEFT OUTER JOIN mfgtrain.pt_mstr T2 on T1.tr_part = T2.pt_part }
order by T2.pt_prod_line asc
select T3.pl_desc, T3.pl_prod_line
from mfgtrain.pl_mstr T3
order by T3.pl_prod_line asc
为什么不把三表T1,T2,T3 LEFT JOIN起来而是分两个SELECT?
收起