What is the difference of a LEFT JOIN and an INNER JOIN
statement? What is a Cartesian product? What causes it?
Answer Posted / janardan baghla
Left join is used to retrieve the non-matching value from
the left table specified at left in query.And inner join or
equi join is used to retrieve the matching rows
only.Cartesian product is used to retrieve the value as
multiplication of the rows from number of tables specified
in query
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the ways to sending the data in ASP.NET page?
What are the different session state management options available in asp.net?
What is difference between inproc and outproc?
How to make sure that contents of an updatepanel update only when a partial postback takes place (and not on a full postback)?
What is a session in programming?
What is inproc mode in session?
What is the difference between a multi-layer and multi-tier applications?
What is difference between cache and session?
How many types of sessions in asp.net?
What is enableviewstate in asp net?
Where the assembly is stored in asp.net?
Is global asax mandatory?
Explain the steps to be followed to use passport authentication.
explain code with datachaching with example
What is a server farm in iis?