Answer / neha gupta

The act of joining in MySQL refers to smashing two or more
tables into a single table.In short, a join command unites
some or all of the data from two or more tables into one
comprehensive structure.

Types of Join

1. Inner Join
2. Outer Join
Left Outer Join
Right Outer Join
3. Self Join

Answer / vijay

Types of join are:-
1.Outer join
*--Right Outer join
*--Left Outer join
*--Full Outer join
2.Multiple join
3.self join
4.Inner join
5.cross join

Answer / amita

types of joins are
cross join
inner or equi join
left join
right join
outer join

Answer / vijay

Join:-
Join are used to retrieve data from more than one
table simultancously .
Types of join are:-
1.Outer join
*--Right Outer join
*--Left Outer join
*--Full Outer join
2.Multiple join
3.self join
4.Inner join
5.cross join

Answer / shahzad

join clause is used combines records from two or more tables
in a database.it means combining fields from tables common
to each.

There are 4 common types of join
1-inner
2-outer
3-left
4-right
and special case is "" self-join ""

1-inner join
Equi-join
Natural join
Cross join
2-Outer joins
Left outer join
Right outer joins
Full outer join
other tpes are hash and merge join bu these are algorith
implementation.

Answer / aurang zeb khan

Joins are the oprators used to combines the records or
attributes of the two or more tables.

Answer / muthu malai.g

join is used to retrive the datas from more than one
tables.types are inner join,outter join,cross join,equity
join,non equity join

Answer / antergen suvi danis

Join Syntax:

table_references:
table_reference [, table_reference] ...

table_reference:
table_factor
| join_table

table_factor:
tbl_name [[AS] alias] [index_hint)]
| table_subquery [AS] alias
| ( table_references )
| { OJ table_reference LEFT OUTER JOIN table_reference
ON conditional_expr }

join_table:
table_reference [INNER | CROSS] JOIN table_factor
[join_condition]
| table_reference STRAIGHT_JOIN table_factor
| table_reference STRAIGHT_JOIN table_factor ON
conditional_expr
| table_reference {LEFT|RIGHT} [OUTER] JOIN table_reference

join_condition
| table_reference NATURAL [{LEFT|RIGHT} [OUTER]] JOIN

table_factor

join_condition:
ON conditional_expr
| USING (column_list)

index_hint:
USE {INDEX|KEY} [FOR JOIN] (index_list)
| IGNORE {INDEX|KEY} [FOR JOIN] (index_list)
| FORCE {INDEX|KEY} [FOR JOIN] (index_list)

index_list:
index_name [, index_name] ...

Types of join are,

* Inner Join
* Left Join or Left Outer Join
* Right Join or Right Outer Join
* Equi join
* Non Equi Join
* Natural Join
* Straight Join

Answer / ammu

joins are nothing but a condition that combines two or more table resulting with an single table
types of joins :
--> inner join
*equi join
*cross join
--> outer join
*left outer join
*right outer join
*full outer join
--> self join

Answer / naveen

when data from more than one table in the database is
required,a join condition is used.
select empno,ename,dname,loc from emp,dept;
equi join
non-equi join
self join
outer join
cartesian join

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

0 Answers  

What is mysql and how it works?

0 Answers  

How will show all records containing the name "sonia" and the phone number '9876543210'

0 Answers  

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

0 Answers  

Does insert statement lock the table?

0 Answers  

What is data type for image in mysql?

0 Answers  

How show all tables in mysql query?

0 Answers  

What is 'mysqld'?

0 Answers  

What are aggregate functions in mysql?

1 Answers  

What is Database?

2 Answers  

How to use like conditions?

0 Answers  

Explain what is mysql?

0 Answers