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

Is sql a backend?

966

How to run sql statements with oracle sql developer?

997

What is dense_rank in sql?

915

What is a composite primary key?

1030

What is a mutating table and a constraining table?

1029

What are the three pl sql block types?

945

Explain dml and ddl?

919

What is the purpose of the primary key?

1003

Is it possible to read/write files to-and-from PL/SQL?

1033

Inline the values in PL/SQL, what does it mean.?

1154

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1123

Why sql query is slow?

928

What is a sql select statement?

990

what is sql server agent? : Sql dba

1026

What is a join query?

903