Interested to Buy Any Domain ? << Click Here >> for more details...
what is JOIN? Give example & types of join?
- 14 Answers
- 42529 Views
- iMedia, Millennium, RAM Software, Satyam, I also Faced
- E-Mail Answers
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
Does mysql automatically index foreign keys?
How many sql ddl commands are supported by 'mysql'?
How to run a sql statement?
How many ways to get the current time?
What is difference between mysql and mysqli?
How do I start mysql database?
How to load data files into tables with 'mysqlimport'?
How can I see mysql database?
What are the differences between char and varchar data types?
Explain the difference between procedure and function in mysql?
What storage engines are used in MySQL?
What is different between sql and mysql?
What is table level locking in mysql?
What are numeric data types?
What is a session in mysql?
