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

A form has four mandatory fields to be entered before you submit. How many numbers of test cases are required to verify this? And what are they?

748


hai friends can u expalin about real time process of testing at the company, like flow diagram

1715


Explain crud testing.

739


test measurment techniques

1707


What is test driver and test stub?

776






1. what is baseline document , can you say any two ?

1954


What is the difference between functional requirement and non-functional requirement?

760


What is deferred status in defect life cycle?

827


What is your approach when requirements change continuously?

801


What is a code walk through?

740


Hi everyone, My name is Salil Mishra. I am having 1.7 years of experience in manual testing. But as i m 2008 passout, there are limited position for me in the companies. Please help me out in getting a good job guys..I f you find something then please mail me at salilmishra29@gmail.com

1619


can any one send sample test cases for database testing by taking an example? also leave emailid please. thanks (very urgent)

2771


What is the Testing strategy for testing client server applications/products?

1949


1) Difference between "Delete" and "Concatenate" with reference to databases? 2) Difference between SDLC and STLC. 3) Latest versions of the browsers used. 4) What is URL Tampering? 5) Full form of URL. I don't need the answers. These are just for reference.

2052


What are the RBI rules has to follow by a bank for online precesseing. ?

1798