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 happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
What is blob and text in mysql?
Which is faster innodb or myisam?
How to create trigger in mysql phpmyadmin?
What is the purpose of using ifnull() function?
What is a heap table?
How can I remotely connect to mysql database?
What is a storage engine? What are the differences between innodb and myisam engines?
Why are function needed?
What command is used to delete the data from the table without deleting the table structure?
What is mysqladmin flush hosts?
What is ndb in mysql?
What do you understand by mysql terminal?
What are enums used for in mysql?
What is a trigger? How you can create a trigger in mysql?