Discussion in 'SQL PL/SQL' started by bnramesh8, Sep 4, 2014.
What is the alternative for FULL OUTER JOIN?
A full join, an inner join, no join, a cartesian product, a left outer join, a right outer join...you might as well as what is the alternative to blue.
What's the real question?
Hi Refer these links. those may give an idea
Additional links : Join
Simple example :
CREATE TABLE T11
SELECT 1 A , 2 B FROM dual UNION ALL
SELECT 2 , 3 FROM dual UNION ALL
SELECT 3 , 5 FROM dual;
CREATE TABLE T22
SELECT 7 X , 2 Y FROM dual UNION ALL
SELECT 8 , 4 FROM dual UNION ALL
SELECT 9 , 4 FROM dual;
FROM t11 t1
FULL JOIN t22 t2 ON t2.x = t1.a
t2.y = t1.b;
FROM T11 LEFT OUTER JOIN T22
ON (T11.A > 9 AND T11.B = T22.Y);
My Query is i want to retrieve the full outer join result with out using full outer join keyword?
it is necessary to execute sequence of operations over tables which need to be joined : left join and right join and union all
So instead of :
from emp e right outer join dept d
...which is ANSI SQL
from emp e, dept d
where e.deptno(+) = d.deptno
where e.deptno = d.deptno(+)
...depending on what you want to do. These latter entries are Oracle's specific Outer Join syntax.
That's like saying you want to insert rows into a table without using the INSERT command. It may be possible to do (i.e. you could use MERGE instead of an INSERT), but whether or not it is a valid solution for the problem you are trying to solve depends on what the real problem is.
In your case... if the data you want to retrieve is that which you would normally use a FULL OUTER JOIN for, what is the specific reason that you do not want to use the standard syntax?