what is JOIN? Give example & types of join?
Answer Posted / 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
| Is This Answer Correct ? | 81 Yes | 12 No |
Post New Answer View All Answers
What is mysql database used for?
How do I copy an entire mysql database?
What is mysql port?
Does mysql use t sql?
How to create a table index in mysql?
Can you tell few best practices to be followed for optimization in sql?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
How do I setup a mysql database?
What are ddl statements in mysql?
What is 1nf 2nf 3nf?
What is the password of mysql?
How do I view mysql logs?
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
How do I rename a table in mysql workbench?
What are the functions used to encrypt and decrypt the data present in mysql?