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
What is longblob in mysql?
What is a tinyint in mysql?
Explain about the architecture of MYSQL?
What can you do with mysql?
How can you filter the duplicate data while retrieving records from the table?
What is the use of mysqli_query?
What are the differences between mysql vs sql server?
How to use mysqldump to create a copy of the database?
How do I install mysql on windows 10?
What is limit in mysql?
What are the 'mysql' command line options?
What is foreign key in mysql?
What is a csv table?
How to connect html form to mysql database using php?
I want to find out all databases starting with ‘test’, I have access to?