what is JOIN? Give example & types of join?

Answer Posted / ammu

joins are nothing but a condition that combines two or more table resulting with an single table
types of joins :
--> inner join
*equi join
*cross join
--> outer join
*left outer join
*right outer join
*full outer join
--> self join

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why are function needed?

487


What is triggers and how it can be used in mysql?

526


Which datatype is used for email in mysql?

478


What are the different types of triggers in mysql?

453


Why is mysql popular?

483






How to display top 10 rows in mysql?

574


How to delete a table.

512


Can not connect to mysql server 10060?

496


What are the similarities between a function and a procedure?

450


What is a text delimiter?

506


How do I set user privileges in mysql?

474


How does select query work?

489


Which statement is used in a select query for partial matching?

608


What is a transaction? Describe mysql transaction properties.

534


If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

496