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
- 9821 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 conditional testing? explain and examples
HI. ANYONE HAS ATTENDED INTERVIEW FOR TESTING IN MINDKRAFT GLOBAL. I HAVE WRITTEN TEST FOR SOFTWARE TESTING. CAN ANYONE TELL ME WHAT ALL QUESTIONS CANBE ASKED. PLS REPLY. THANK YOU
What do you like about computers?
What is Test Design?
What is strategy to be followed for execution of 500 Test Cases in One day. If only 1 Resource is available.
what is the impact analysis?
My name is Akpos from Nigeria. I have finished manual testing course. Please, can someone advise me where to go on from here?
How we will test ubercate
What is performance tuning? What are tools of performance testing?
define Testing of Procedure, Triggers and Functions in data base testing ?
What is quality center? What are the modules of quality center?
please give information about ERP Projects and how V-model use in project
Explain the advantages of automation over manual testing?
Can you explain usability testing?
hi can anyone tell me about vision plus testing? and what about its future
