Interested to Buy Any Domain ? << Click Here >> for more details...
what is JOIN? Give example & types of join?
- 14 Answers
- 41969 Views
- iMedia, Millennium, RAM Software, Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is inner join in mysql?
What is select query in mysql?
How to use 'mysql' to run sql statements?
Where is the mysql config file?
What is the purpose of mysql database?
List data types in mysql? Explain
How many columns can you create for an index?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
How do I change the max connection in mysql?
What is mysql database server?
Which software is used for mysql?
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
How do you backup a database in mysql?
How is myisam table stored?
Is mysql a server?
