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 does mysql workbench do?
What is bigint in mysql?
How does mysql store dates?
What is mysql database extension?
What is difference between mongodb and mysql?
What is the data type for file in mysql?
How to shut down the server with 'mysqladmin'?
What storage engines are used in MySQL?
What are date and time data types in mysql?
How to dump a table from a database.
Do you need a license for mysql?
How do I transfer data from one database to another in mysql?
What is dblink?
How do I start mysql in ubuntu?
How do I stop a query in mysql workbench?