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 is mysqli_num?
What does schema mean?
How to use mysqldump to create a copy of the database?
What is the datatype of image in mysql?
write a command to view the content of the table
What are the functions of mysql?
What is the role of a limit in a mysql query?
What does the file with the extension: frm, myd, and myi contain?
What is the difference between having and where clause in mysql? Explain
Are stored procedures precompiled?
what is database black box testing? : Mysql dba
What is regexp?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
What is text?
What is mysql in dbms?