What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,
Answer Posted / sunil kumar
Inner join=>Inner join returns rows when there is at least
one match in both tables.
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.
Right Outer Join=>Return all the rows of second table ,plus
matching record of both tables.
Left Outer Join=>Return all the rows of first table,plus
matching record of both tables.
Is This Answer Correct ? | 26 Yes | 0 No |
Post New Answer View All Answers
What is mysql shell?
What is the maximum no of columns a table can have?
How do I change directories in mysql?
Does insert statement lock the table?
how can you test for null values in a database? : Mysql dba
How do I install the latest mysql on ubuntu?
How do stored procedures work?
What is mvcc in mysql?
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
What storage engines are used in MySQL?
How to get a list of indexes of an existing table?
What is the limit of mysql database?
What are the indexes in mysql?
How do I install mysql workbench?
What is mysql architecture?