what is JOIN? Give example & types of join?

Answer Posted / naveen

when data from more than one table in the database is
required,a join condition is used.
select empno,ename,dname,loc from emp,dept;
equi join
non-equi join
self join
outer join
cartesian join

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is longblob in mysql?

522


What is a tinyint in mysql?

483


Explain about the architecture of MYSQL?

548


What can you do with mysql?

487


How can you filter the duplicate data while retrieving records from the table?

472






What is the use of mysqli_query?

448


What are the differences between mysql vs sql server?

475


How to use mysqldump to create a copy of the database?

502


How do I install mysql on windows 10?

505


What is limit in mysql?

440


What are the 'mysql' command line options?

502


What is foreign key in mysql?

595


What is a csv table?

543


How to connect html form to mysql database using php?

481


I want to find out all databases starting with ‘test’, I have access to?

670