OraFAQ Forum: Server Administration » Re: Select a.x ,b from (select x) a, b question.

Home » RDBMS Server » Server Administration » Re: Select a.x ,b from (select x) a, b question.

Tue, 01 May 2001 14:57

Jaco
Messages: 23
Registered: August 2000

Junior Member

SELECT e.name,
eb.no_insurance
FROM emp e,
(SELECT b1.id,
b1.no_insurance
FROM b b1, emp e
WHERE b1.id = e.id
AND rownum = 1) eb

Hope this helps!

Previous Topic:	Re: Select a.x ,b from (select x) a, b question.
Next Topic:	what is the diff between -select table_name from all_tables;and select * from tab?

Goto Forum:

]

Current Time: Mon Dec 23 09:28:08 CST 2024