Interested to Buy Any Domain ? << Click Here >> for more details...
what is JOIN? Give example & types of join?
- 14 Answers
- 41941 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
How can I connect mysql database?
What is dblink?
How to create and drop view in mysql?
Is Mysql query is case sensitive?
What is query log in mysql?
How do I start mysql server?
How to make a copy values from one column to another in mysql?
What is difference mysql and mysqli?
What is mysql community server?
How to shutdown mysql server?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
How do I download mysql on my laptop?
How can you handle the –secure-file-priv in mysql?
What are procedures in mysql? Explain
What is definer in mysql?
