what is JOIN? Give example & types of join?
Answer Posted / ammu
joins are nothing but a condition that combines two or more table resulting with an single table
types of joins :
--> inner join
*equi join
*cross join
--> outer join
*left outer join
*right outer join
*full outer join
--> self join
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is foreign key indexed mysql?
Are stored procedures precompiled?
How to get nth highest salary from table in a mysql?
Will mysql remain free?
write a command to view the content of the table
What do I do if I forgot my mysql root password?
How do you rename a table?
How do I start and stop mysql on windows?
What are procedures in mysql?
How to display top 10 rows in mysql?
What data type is money?
Can we save images in mysql database?
What is not null in mysql?
What is clob datatype?
What is insert query in mysql?