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

Which software is used for mysql?

0 Answers  

Explain advantages of InnoDB over MyISAM?

1 Answers  

What is the default port for MySQL Server?

0 Answers  

What is localhost in mysql?

0 Answers  

What are the differences between char and varchar data types?

0 Answers  

How to enter boolean values in sql statements?

0 Answers  

How do I flush privileges in mysql?

0 Answers  

What is deterministic in mysql?

0 Answers  

Write a query to retrieve a hundred books starting from 20th.

0 Answers  

What is a mysql model?

0 Answers  

What does mysql_query return?

0 Answers  

What does innodb stand for?

0 Answers