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
How do I completely remove mysql from windows?
What are the disadvantages of mysql?
What is a data directory?
What is the difference between mysql and oracle?
How do I change directories in mysql?
What is the password of mysql?
What is limit in mysql?
What are the similarities between a function and a procedure?
How to get the number of rows selected or affected by a sql statement?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What are the limitations of mysql?
Differentiate CHAR_LENGTH and LENGTH?
What is the data type for image?
What mysql means?
Is foreign key indexed mysql?