how to join two table?

Question Posted / guest

2 Answers
4028 Views
iNautix, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to join two table? ..

Answer / partha

There are two types of join inner join and outer join.

(1)Inner join will return all the common records in both the
table
Ex: Select e.ename from Employee e,Dept d where e.did=d.did;

(2)Outer join is of 3 types Left Outer,Right Outer and full
outer.
Left outer retrieves common records from both the table and
all the record from the left table.
Similarly Right Outer all the records from right table and
Full outer from both the tables

Is This Answer Correct ?

21 Yes

0 No

how to join two table? ..

Answer / n

Inner and outer joins

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Database Management Interview Questions

I am using Oracle 10g and want to access the default tables of 9i? how? Any script and how to use it please mail me @ rashi.sandhu@gmail.com........