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
Can a table have multiple primary keys?
What is required to create mysql database?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
What is dblink?
How do I declare a variable in mysql?
How to create a new view in mysql?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
What is difference between oracle sql and mysql?
How to install mysql?
How can we get the number of rows affected by query?
How can you handle the –secure-file-priv in mysql?
What language is used in mysql?
Why is the basic difference between left join, right join and inner join?
How to find second highest salary from a table?
How to show table names with 'mysqlshow'?