full outer join. select ename,sal,dname,loc,e.deptno from emp e full o

How do you get all records from 2 tables. Which join do you use?

Question Posted / gvmahesh

Answer Posted / gvmahesh

full outer join.

select ename,sal,dname,loc,e.deptno from emp e
full outer join dept d on e.deptno=d.deptno;

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a nested table in word?

1009

What is the difference between functions, procedures, and packages in pl/sql?

1092

Can we perform dml in function?

1130

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1247

how can we destroy the cookie? : Sql dba

1081

How many parts of a pl sql block are optional?

1218

Why sql query is slow?

1041

How much does sql cost?

1067

What is meant by cursor in sql?

1061

Is primary key clustered index?

992

What is 19 null in sql?

1017

What are the main features of cursor?

1108

What is sql prepared statement?

1032

Can we use joins in subquery?

1223

How many types of functions are there in sql?

1005