select nome, end, (select * from tab2) from tab1
select nome, end from tab1, (select * from tab2)
Fico grato!
select nome, end, (select * from tab2) from tab1
select nome, end from tab1, (select * from tab2)
select nome, end, (select * from tab2) from tab1
select nome, end from tab1, (select * from tab2)
select nome, end, tab2.* from tab1, (select * from tab2)
Select t1.nome, t1.end, total.salario
from tab1 t1
,(select salario
from tab2
where total > 1) total
where t1.nome like 'A%'
select em.*, (select dname from dept dp where dp.deptno = em.deptno) dname from emp em
/
select em.*, d.dname from emp em, dept d where d.deptno = em.deptno
/
Usuários navegando neste fórum: Nenhum usuário registrado e 10 visitantes