what is JOIN? Give example & types of join?

Answer Posted / muthu malai.g

join is used to retrive the datas from more than one
tables.types are inner join,outter join,cross join,equity
join,non equity join

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different types of constraints?

516


What are the features of mysql?

512


How do I fix a crashed mysql database?

491


What is federated tables in mysql?

464


How many columns can you create for an index?

487






What is cast in mysql?

474


What is mysqli_free_result?

506


how to take mysql database backup?

576


Why we use mysql database?

483


What is max connections in mysql?

486


How to dump one database for backup.

492


What are the advantages and disadvantages of using mysql?

500


Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

497


How to show all records starting with the letters 'sonia' and the phone number '9876543210'

513


What language does mysql use?

432