Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by Join? What are the different types of
Joins available? Explain.
- 5 Answers
- 17108 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kilari hemadri
Joins is used to relate two tables and display the result..
types of joins are
inner join
left join
right join
full join
cross join
inner join : It is used to display the common values in
both the tables based on the condition given.
left join : Left join displays all the contents of left
table and dislays the right table contents that are present
in left table.
right join : it is contraversy to left join
full join : it is combination of both left and right joins.
cross join: it takes one row of left table and matches with
all the rows in the right table.
| Is This Answer Correct ? | 16 Yes | 4 No |
Answer / jiya jain
The nature of relational database design shows that we will
have related data that is stored in different tables. To
retrieve data from two or more tables we use JOINS.
The JOIN clause tells the database how the data in the two
tables is related so that it can return a correct
representation of the related data.
There are different types of join.
Types of Join are :
1.Self Join
2.Inner Join
3.Outer Join
3.1. Right Outer Join
3.2. Left Outer Join
3.3 Full Outer Join
4.Cross join College Table
For more info go through
http://www.totaldotnet.com/Article/ShowArticle61_SqlServerJo
ins.aspx
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mahesh
joins are used to relate two tables and display the result..
Types of join
1.inner join
2.outer join
2.1 left outer join
2.2 right outer join
2.3 full outre join
3.cross join
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / udaykumar
Join - joining of two tables to itself.
types of joins.....
simple/equi/inner
self
outer
cartesian.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dinesh kumar
Joins -- Getting related data from more than one table.
Type:
Inner JOin --Equi Join -- Non Equi join
Outer JOin --LEft Join -- Right Join -- Full Outer JOin
CRoss Join
| Is This Answer Correct ? | 0 Yes | 0 No |
How insert into statements in sql?
25.67,-1 Trunc = 20 Round= 30 HOW????
What is sql performance tuning?
how can we repair a mysql table? : Sql dba
What are aggregate and scalar functions?
what is an extent ? : Sql dba
What is a temp table?
I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.
What is sql prepared statement?
What is %type in pl sql?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is the different between Stored Procedure and Procedure?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
