full outer join syntax

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / arpitha2206

5 Answers
8552 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

full outer join syntax..

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

full outer join syntax..

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

full outer join syntax..

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

full outer join syntax..

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

full outer join syntax..

Answer / ambedkar

At first Full outer join is never not possible.

Is This Answer Correct ?

0 Yes

4 No

Post New Answer