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

Can we call stored procedure in function?

964

how do you tune the slow running queries in oracle db , explain the methodology

2814

What is embedded sql in db2?

1022

Can you inner join the same table?

995

how many groups of data types? : Sql dba

1029

How show all rows in sql?

1016

What is the difference between sql and mysql?

1123

Are stored procedures faster than queries?

948

How do I find duplicates in sql?

935

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1163

Can dml statements be used in pl/sql?

1083

what is a database transaction? : Sql dba

1189

how to drop an existing table in mysql? : Sql dba

1048

What is scalar function in sql?

1045

How can you fetch first 5 characters of the string?

1018