what is JOIN? Give example & types of join?
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
Is oracle mysql free?
What is dump in mysql?
Why do we use mysql?
How do I select a table in mysql?
Can you tell few best practices to be followed for optimization in sql?
Should I use pdo or mysqli?
Is mysql still relevant?
Why we use mysql workbench?
Is mysql a programming language?
Is mysqli faster than mysql?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
How does mysql store dates?
How do you login to MySql using Unix shell?
Where is the mysql database stored?
What is the full meaning of mysql?