left join可以连接两表数据 可以用on 和 where 连接两表数据
select tp.processname,
tp.nodename,
tp.plantime,
tk.maxtime,
tk.mintime,
tk.avgtime
from (SELECT DISTINCT t1.processname,
t4.nodename,
to_char(t3.day / 3600 / 24,
'9999999990.99') AS plantime
FROM losd_process t1,
losi_taskplan t2,
losi_itemplan t3,
losd_node t4
WHERE t1.process_id = t2.task_id
AND t2.board_id = t3.board_id
AND t1.process_id = t4.process_id
AND t4.node_id = t3.element_id
AND t4.nodetype = 2
AND t3.elementtype = 1) tp
left join (select s.nodename,
s.processname,
to_char(max(s.time), '9999999990.99') maxtime,
to_char(min(s.time), '9999999990.99') mintime,
to_char(avg(s.time), '9999999990.99') avgtime
from (select (t.finishtime - t.receivetime) as time,
n.nodename,
p.processname
from losi_token t,
losd_node n,
losd_process p
where t.nodetype = 2
and t.node_id = n.node_id
and n.process_id = p.process_id
and t.finishtime is not null) s
group by s.nodename, s.processname) tk
on (tp.processname = tk.processname and
tp.nodename = tk.nodename)
