what is JOIN? Give example & types of join?
- 14 Answers
- 39826 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 a mysql model?
What are the benefits of mysql?
Does mysql automatically index foreign keys?
What is procedural api?
How to show all tables with 'mysql'?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
How does mysql store binary data?
Can a table have multiple primary keys?
What is text?
In mysql, what is the default storage engine?
using primary can we relate two table, with out foreign key?
What is meant by decimal (5,2)?
What are the features of mysql?
If you wish to encrypt the username and password using php, how will you do that?
What is 'mysqlimport'?
