What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me
How does mysql encrypt passwords?
What is new mysqli?
Write a program using the select statement, while loop.
What is mysql enterprise edition?
How do I rename a procedure?
How do you say mysql?
What is definer in mysql?
What are the advantages and disadvantages of using mysql?
What is row level locking in mysql?
Why use mysql procedures?
what is database black box testing? : Mysql dba