Ayuda con una vista
Pedro Rosas
12 de Septiembre del 2003
es posible realizar en Oracle una vista utilizando la instruccion UNION.
Algo asi:
select distinct(numentcon), CveEntEmp, Sum(MtoEntCom)
from (
(select NumentCon, CveEntEmp,CanMovEmp MtoEntCom from movqnaemp where cveentqna=0 and cveperded=510311)
union
(select numentcon,CveentEmp, 0 MtoPerDed from detentemp order by numentcon)
group by numentcon, CveentEmp
Algo asi:
select distinct(numentcon), CveEntEmp, Sum(MtoEntCom)
from (
(select NumentCon, CveEntEmp,CanMovEmp MtoEntCom from movqnaemp where cveentqna=0 and cveperded=510311)
union
(select numentcon,CveentEmp, 0 MtoPerDed from detentemp order by numentcon)
group by numentcon, CveentEmp
Adrian
12 de Septiembre del 2003
Si