full outer join syntax
Answers were Sorted based on User's Feedback
Answer / thiyagarajan
select table1.columnname1,table2.columnname2
from
table1 full outer join table2
on
table1.colname=table2.colname
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / madhav
Full outer join
select e.empno,e.ename,e.deptno,e.sal,d.deptno,d.dname from
emp e full outer join dept d
on e.deptno=d.deptno;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / avi007
full outer join -
select * from table1,table2 where
table1.columnname(+)=table2.colunmname;
union
select * from table1,table2 where
table1.columnname =table2.colunmname(+);
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / naresh
select * from table full outer join tablename2;
or
select * from table1,table2 where
table1.columnname(+)=table2.colunmname(+);
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / ambedkar
At first Full outer join is never not possible.
Is This Answer Correct ? | 0 Yes | 4 No |
Is keyword pl sql?
What is differance unique key and primary key.
What is the difference between delete and truncate statement in sql?
How can you tell the difference between an index and a view?
Can we write create command in the plsql block?if possible how?
What is a clob in sql?
how to show all tables with 'mysql'? : Sql dba
Why is pl sql used?
Are sql connections encrypted?
What is difference between function and trigger?
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
What is sql not null constraint?