what is JOIN? Give example & types of join?
- 14 Answers
- 39700 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 to update info already in a table and delete a row(s) from a table.
How do I quit mysql?
What is dump in mysql?
What is pragma exception?
Does facebook still use mysql?
How can you make a database as your current database?
What are the difference between now and current_date in mysql?
What is the use of mysqli_num_rows?
Can you tell the difference between $message and $$message?
Can you tell how to find the number of rows in a resultset using php?
What is mysql data directory?
How do I create a schema in mysql?
What is 1nf 2nf 3nf?
What port is mysql running on?
How do I get a list of table names in mysql?
