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
Which is better asp.net or php?
How long the items in ViewState exists?
Which protocol is used in a web api?
What is the difference between user control and custom control?
Which is better session or viewstate?
Explain About duration in caching technique
What is redirecting behavior?
What is a nested masterpage in asp.net 2.0? Can there be a master page inside a masterpage?
Explain server side state management system.
What is a server cookie?
Explain Areas in MVC?
What is the basic purpose of the required field validator? How can you use a required field validator to check that the user changes the initial value of a text box? a listbox?
How do you secure your configuration files to be accessed remotely by unauthorized users?
Explain the server control events of asp.net ?
Fetch one page value to another page without using state-managment ?