create view toProcessView as select
t.t_id,t.t_desc,t.t_lssuer,t.t_performer,p.stime p.rtime from (select *
from task t union all process p )where t.processId=p.processId;
create view toProcessView as select
t.t_id,t.t_desc,t.t_lssuer,t.t_performer,p.stime p.rtime from (select *
from task t union all process p )where t.processId=p.processId;