select a.empno,empname,deptname,group,password,sum(b.number1) from a,b where a.empno=b.empno(+) group by a.empno,empname,deptname,group,password
select empno,empname,deptname,group,password,(select sum(number1) from b where b.empno=a.empno) from a
select a.empno, a.empname, a.deptname, a.gp, a.pwd,b.sumber from A a left join (select empno ,sum(number1) sumber from B group by empno) b on a.empno=b.empno;
select t0.empno, t0.empname, t0.deptanme, t0.groupid, t0.passwork, t1.number1 from A t0, (select empno, sum(number1) as number1 from B group by empno) t1 where t0.empno = t1.empno(+) order by t0.empno;
where a.empno=b.empno(+) group by a.empno,empname,deptname,group,password
select a.empno, a.empname, a.deptname, a.gp, a.pwd,b.sumber from A a left join
(select empno ,sum(number1) sumber from B group by empno) b on a.empno=b.empno;
select t0.empno,
t0.empname,
t0.deptanme,
t0.groupid,
t0.passwork,
t1.number1
from A t0,
(select empno, sum(number1) as number1 from B group by empno) t1
where t0.empno = t1.empno(+)
order by t0.empno;