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
- 9693 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
can u plz give an example for regression testing with example.
How do you test for the coockies for a web application?
value momentum
do we need to write test cases for workflow of the product for instance: there is 2 module "TRAINING ASSIGN MODULE" and "EMPLOYEE" in TRAINING assign MODULE iam assigning training to employee setp is 1.selct traning "oracle" 2.select employee u want assign "peter" 3.apply. now to check whether training assign or not GOTO EMPLOYEE module 1.click on "peter" 2.click on 'view assign to employee'link.now this is a flow do i need to write test cases for this fllow.plz help me guy mail me nirmal_rawatt@rediff.com
What is Difference between Test Strategy and Test Methodology?
Why you are selected software testing as career ?
Hi to all, im vaibhav i joined a MNC as a tester and i got a banking (HSBC) project can any one tell me as a fresher what kind of strategy i sholud use to perform better. thanx
Any one please can u tell me what is composer? An interviewer asked me do u have experience in Composer? its urgent.
Hi there Does anybody can respond to my Questions? Is some one there to answer my Questions posted in Software testing category.pls E-mail to sunitht27@yahoo.com
How do you determine user soad for a perf test of a Web application?
How do your characteristics compare to the profile of the ideal manager that you just described?
functional testing test cases for transfer funds ?
What is Windows Test Technologies? Where i will get all information of it.
What is a ‘test plan’?
what is the difference between section & test feature in test case documention?
