Interested to Buy Any Domain ? << Click Here >> for more details...
what is JOIN? Give example & types of join?
- 14 Answers
- 41963 Views
- iMedia, Millennium, RAM Software, Satyam, I also Faced
- E-Mail Answers
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
Is mysql still popular?
What is a transaction? Describe mysql transaction properties.
What is int unsigned?
How do I find mysql location?
How to install mysql?
What is mysql root?
How can you create and drop view in mysql?
How do I find users in mysql?
What is the limit of mysql database?
What is ntext?
What is the difference between char and varchar in mysql?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
How do I edit a table in mysql?
What is mysqli_num?
Does mysql case matter?
