What are inner join and outer join?




Answers were Sorted based on User's Feedback



What are inner join and outer join?..

Answer / akn

Inner join is the most common type of join. Inner joins
return all rows from multiple tables where the join
condition is met.

Outer join returns all rows from one table and only those
rows from a secondary table where the joined fields are
equal (join condition is met).

Is This Answer Correct ?    16 Yes 3 No

What are inner join and outer join?..

Answer / pandian raman

Inner Join (simple join)

Inner joins return all rows from multiple tables where the
join condition is met.

For example,
SELECT suppliers.supplier_id, suppliers.supplier_name,
orders.order_date FROM suppliers, orders
WHERE suppliers.supplier_id = orders.supplier_id;

This SQL statement would return all rows from the suppliers
and orders tables where there is a matching supplier_id
value in both the suppliers and orders tables.
Outer Join

This type of join returns all rows from one table and only
those rows from a secondary table where the joined fields
are equal (join condition is met).

For example,

select suppliers.supplier_id, suppliers.supplier_name,
orders.order_date from suppliers, orders where
suppliers.supplier_id = orders.supplier_id(+);

This SQL statement would return all rows from the suppliers
table and only those rows from the orders table where the
joined fields are equal.

The (+) after the orders.supplier_id field indicates that,
if a supplier_id value in the suppliers table does not exist
in the orders table, all fields in the orders table will
display as <null> in the result set.

The above SQL statement could also be written as follows:

select suppliers.supplier_id, suppliers.supplier_name,
orders.order_date from suppliers, orders where
orders.supplier_id(+) = suppliers.supplier_id

Is This Answer Correct ?    9 Yes 1 No

What are inner join and outer join?..

Answer / omprakash.jsm

Inner join return rows from many tables where the join field and data type are equal.

outer join return rows from many tables where the join field are not equal but data type will be same.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer



More Oracle General Interview Questions

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,


select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 Answers  


in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

2 Answers   Polaris,


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

0 Answers  


T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,






How many memory layers are in the shared pool?

1 Answers  


What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  


what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

2 Answers  


What is an Index ? How it is implemented in Oracle Database ?

4 Answers  


structural difference between bitmap and btree index ?

1 Answers   Infosys,


What the is the diff between local index and global index. give some example.

0 Answers   TCS,


sql query to get zero records from a table

7 Answers   CTS,






Categories