1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / geethu

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

More SQL PLSQL Interview Questions

What are all types of user defined functions?

0 Answers  

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

What is sap sql anywhere?

0 Answers  

Determine if oracle date is on a weekend?

0 Answers  




Explain scalar functions in sql?

0 Answers  

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

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

0 Answers  

Is subquery faster than join?

0 Answers  

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

how can we submit a form without a submit button? : Sql dba

0 Answers  

difference between SQL and C

1 Answers   Indus Software Technologies,

For more SQL PLSQL Interview Questions Click Here
Categories