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

Can a table have multiple primary keys?

897

---

What is required to create mysql database?

980

---

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2113

---

What is dblink?

890

---

How do I declare a variable in mysql?

940

---

How to create a new view in mysql?

922

---

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

1350

---

What is difference between oracle sql and mysql?

1011

---

How to install mysql?

1016

---

How can we get the number of rows affected by query?

1049

---

How can you handle the –secure-file-priv in mysql?

938

---

What language is used in mysql?

987

---

Why is the basic difference between left join, right join and inner join?

1028

---

How to find second highest salary from a table?

1018

---

How to show table names with 'mysqlshow'?

1030

---