self join query in sql.
15 objective questions.
What is equi join and outer join
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
Login screen with Username, Password input fields,remember me check box,sign in and reset button write Test Cases for GUI, Funcitonal, Negative, Usability and Security testing.
hello frens. Im Arun from the uk. im planning to apply for tester jobs with 3yrs experience. the problem is i dont have resumes. i have to mention atleast 3 projects (preferably financial projects) in my CV. im totally blank. can u plz send ur CV's to my email.... arunmoses1982@yahoo.com. this would be a great help from you guyz. n u need any help from me? just mail me n ill get in touch with u. Thanx.
What is the most important phase in STLC and Why
what is difference between win 98 and win 2000 poertating system?which is better one?
i want information about API testing and i want info like how process can be done in company? i want added info like coding ,debugging, desing in c.v ? what should add in c.v for eg banking domin? pls any answer my question?
can anyone help me regarding testing patterns?
How to do manual testing of a E-insurance project (end to end process)
write test case for gmail sign up page?
What is the purpose of test strategy?
Tell me the SRS based review,brs based review
What is boundary value testing? Give an example.
Name three reasons why the tester may choose to record in Context Sensitive mode.
I studied MBA, I want learn any softwarecourse, which course is better hadoop or testing tools(manual+selenium?)
When do we perform smoke testing?
1.What types of documents would you need for QA, QC, and Testing?