Interested to Buy Any Domain ? << Click Here >> for more details...
self join query in sql.
15 objective questions.
What is equi join and outer join
- 2 Answers
- 9729 Views
- Bally Technologies, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
If anyone have attended interview with deloitte for the post of senior manual test engineer. Please share the interview process and the questions asked. How to prepare for the interview. Thanks in advance
What are the different servers and difference between them?
What is verification in software testing?
Did any one completed CSTE certiication? can u send sample question papers? how to apply that? pls send it to my mail id - dsnathi@gmail.com THANKS IN ADVANCE
What is error cusing tecnique
what type of testing techniques are using after accept the build?
6 what do you like least about testing?
Could someone please send me real check list for Database Security testing.Please my mail ID- patil.ramchandra@yahoo.co.in. Thanks.
can anyone tell anyone is providing training for CSTE exam in bangalore? and can u send some links related to this?
Am putting E-commerce project in my resume can any one please tell me about E-commerce application explaination..
after completeing testing ,what would u deliver to the client?
What is validation in software testing?
What is the role of the test group vis-?is documentation, tech support, and so forth?
.In languages testing, what is the fixed part and changing part?
hi can anyone tell me about vision plus testing? and what about its future
