What are the different types of joins

Answer Posted / knight rider

Types of Joins are:
1.Inner/Simple joins:a)Equi join b)Non-Equi join c)Self join
2.Outer join:a)Left outer join b)Right outer join c)Full
outer join
3.cross join or cartesian product join
4.Natural join

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

integration test cases for mouse and keyboard

3230


What is an inspection in software testing?

676


Does an increase in testing always improve the project?

1352


If anybody from banglore having the real time exp in manual testing with 3+ yrs exp and looking for change send your profile to vinodhanandhan@gmail.com

1509


What is the difference between SIT AND IST?

2604






do we require any scripting languae to write test cases in test director? what for it is used?it is like back end?only database we can there?

1657


is it not possible to automate full project??what r the parts in project that cant be automated(tht has to be done manually)?

1997


Hi , Please send me the interview questions which were asked in manual testing mainly the test cases asked to write in interview.

1506


how will the test plan is pepared in ur organisation>?

1500


Hi Frnds, this is Aman.. can anybody tell me plz what kind of QA Interview questions are asked by IDS Infotech Ltd., Chandigarh? I have lil bit experience only in Manual Testing.. Plz answer my question as soon as possible.. Thnx in advance..

1918


Write a Test scenario for Outlook Search functionality.

2597


I have 2 yrs 10 months experience in manual testing. there is a gap of 3 yrs in between. just 3 months before i rejoined the same company. I am looking for new & better job.What I have to enhance my career to up level, should I have to do Automation course or any other. Guide me properly.

1455


Encapsulation of attributes and operations inside objects makes it easy to obtain object state information during testing. is it true.explain

1647


How to test the below code and write test case? Prove that this code is wrong? int add(int a ,int b) {return a+b; }

1591


Do you think tools are required for managing change. Explain and please list some tools/practices which can help you managing change.

1647