self join query in sql.
15 objective questions.
What is equi join and outer join

Answers were Sorted based on User's Feedback



self join query in sql. 15 objective questions. What is equi join and outer join..

Answer / swaroopa

What is Equi Join and Outer Join ?

Equi Joins are also called Simple Joins or Inner Joins.
An equi-join is a join based on equality or matching
between the column values for two different tables.

This equality is indicated with an equal sign (=) as the
comparison operator in the WHERE clause

Ex:SELECT * FROM manufact, stock
WHERE manufact.manu_code = stock.manu_code

manufact and stock are the tables on the manu_code column.
It retrieves only those rows for which the values of the
two columns are equal.

Outer Join:

OUTER JOIN is used to join two tables even if there is not
a match. The joined table retains each record—even if no
other matching record exists. Outer joins subdivide further
into left outer joins, right outer joins, and full outer
joins, depending on which table(s) one retains the rows
from (left, right, or both).

Is This Answer Correct ?    7 Yes 0 No

self join query in sql. 15 objective questions. What is equi join and outer join..

Answer / latha

self join:one physical table is divided into two logical tables and perform join operation on that tables.
query:
select a.eno,a.ename,b.ename as manager name from emp a,emp b where a.manager num=b.eno
equi join:perform join operations on matching columns on both the tables

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Manual Testing Interview Questions

What is Active and Passive testing ?

2 Answers  


what is security testing? can u please set an example for it?

5 Answers  


Explain clearly what is buglifecycle

3 Answers  


Question on desktop Application: In my machine MS Word is working fine and in other machine it is not even launching. Note: OS, platform, build and environment is same

2 Answers   Intuit,


What is a critical bug?

0 Answers  


Who is the father of software testing?

2 Answers  


Can Any one tell me How to test Stand alone application? wht are the major points to cover & how performance is tested of this application?? can any 1 tell me its bit urget for me guys.

4 Answers  


Did anyone have any experince with stocking in equity can you please tell me how to approach the project.I am a learner.help me please.give me ur suggestions.

0 Answers   CTS, Oracle,


How to Test a C++ and unix application is there any automated tool available,

1 Answers   Calsoft, Primasia,


i joined in qutesys company and i didnt know even what is testing how it is possible?

2 Answers  


Explain a sample testing cycle?

1 Answers   Crea,


hi frinds ,,what is the difference between QA & QC , i need only real time definations ,pls pls

7 Answers   Synergy,


Categories