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
How to calculate the difference between two time values?
What is a deterministic function?
How to delete a column and add a new column to database
How does php communicate with mysql?
What is the difference between unix timestamp and mysql timestamp?
How can I connect mysql database?
How do I show all mysql databases?
How do I run a query in mysql?
How can you filter the duplicate data while retrieving records from the table?
How do I start mysql client?
How to create a new view in mysql?
How can you validate emails using a single query?
What language is used in mysql?
What are the differences between binary and varbinary?
Write a query to stop mysql in unix