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
- 9706 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
what is test case management?explain in brief.
consider therez 1 land and it has mango trees in it, what are the tets cases or how will we count no of mangoes on all trees
What’s the difference between verification and validation in testing?
explain ur testing project? how can u nexplain . what should we explain ? i have not worked on any project?
How to do security implementation for any URL??
what the purpose of requirement phase
how to write the test cases for mark as read/unread mails for gmail inbox?and what are the testings we will do?
i) functional test cases can we consider for regression test ? or we have to write separet test cases for regression test ? ii) How to write the system test case and what are the technique shall we have to follow ?
What is the Difference between Network testing and Web Testing?
is it not possible to automate full project??what r the parts in project that cant be automated(tht has to be done manually)?
What is CVS and why it is used?
HOW TO CREATE SRS REVIEW REPORT TO PL?
Explain the components of a test plan?
During alpha testing why customer people are invited?
What is neutral test case?
