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

How do I pipe the output of one isql to another?

945

explain advantages of myisam over innodb? : Sql dba

1017

Explain scalar functions in sql?

1019

what happens if null values are involved in expressions? : Sql dba

1001

What is a call statement? Explain with an example.

953

what is an index? : Sql dba

933

What are the sql versions?

896

How to run pl sql program in mysql?

942

Can we perform dml on view?

976

when is the use of update_statistics command? : Sql dba

972

What are the two types of exceptions in pl/sql?

969

How do I debug a stored procedure?

1042

What is the difference between inner join and outer join?

931

What is cold data?

898

Can cursors be part of a trigger body?

1588