What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,
Answer Posted / muthuk
Outer Join=> Outer Join returns the set of all matching
records from both tables. Outer join doesn`t require each
record to be matched in both the tables.
Inner join=>Inner join returns rows when there is at least
one match in both tables.
Left Outer Join=>Return all the rows of first table,plus
matching record of both tables.
Right Outer Join=>Return all the rows of second table ,plus
matching record of both tables.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is use of mysql?
How do I assign a variable in mysql?
Why mongodb is faster than mysql?
all the queries used in sql
What is database in php mysql?
What is striped backup
How do stored procedures work?
Write a query to count the number of rows of a table in mysql.
What is session variable in mysql?
What is mysql command line?
What are the ways in which you can retrieve data in the result set of mysql using php?
What is the command line end user interface - mysql?
How do I show users in mysql?
How do I view data in mysql workbench?
Why is it called mysql?