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

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

Question Posted / geethu

8 Answers
19534 Views
Microsoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / rao

Using FULLOUTER JOIN

Is This Answer Correct ?

25 Yes

2 No

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

Answer / vinay

use full outer join you can get the records

Is This Answer Correct ?

8 Yes

0 No

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

Answer / pervez

using full outer join or Cartesian join we can get all records
from two tables

Is This Answer Correct ?

8 Yes

3 No

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

Answer / 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

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

Answer / kavithanedigunta

full outer join in 10 g

select a.*,d.dname
from emp a
full outer join
dept d on
a.DEPTNO = d.DEPTNO

full outer join in 9i

select a.* ,d.DNAME
from emp a, dept d
where a.DEPTNO = d.DEPTNO

Is This Answer Correct ?

4 Yes

0 No

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

Answer / selvaraj v , anna univ coe

Use Full Outer Join in Oracle 10g :

SELECT p.part_id,s.supplier_name FROM part p
FULL OUTER JOIN
supplier s ON p.supplier_idv = s.supplier_id;

Is This Answer Correct ?

3 Yes

1 No

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

Answer / sri

UNION ALL

Is This Answer Correct ?

0 Yes

0 No

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

Answer / mahesh

crartesion product of two tables

Is This Answer Correct ?

6 Yes

8 No

Post New Answer