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 to use case expression?
What happens if null values are involved in expressions?
How to enable or disable a row of a table using MySQL in struts?
How many rows mysql can handle?
What is indexing in mysql?
What is a string in mysql?
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
What is the use of innodb in mysql?
How many rows can mysql hold?
How many concurrent queries can mysql handle?
What does mysql flush hosts do?
How do I start mysql client?
How to delete a column and add a new column to database
What is blob and text in mysql?
What is difference between mysql and mysql server?