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 property needs to be set for script manager control to extend the time before throwing time out expection if no response is received from the server?
Write the different features of a Thread and a Process?
Using code explain Configuration Management
What is difference between rest and soap?
Is asp.net different from asp? If yes, explain how?
What is a viewstate?
What do you mean by authentication?
What is meant by ispostback in asp net?
How will you load dynamic assembly? How will create assesblies at run time?
What is the difference between asp.net and mvc?
What is sql data source control in asp.net?
Which object is used to encapsulate the state of the client and the browser in ASP.NET?
Can we use MSSql as backend in asp.net...if yes then How.?
What is scope of an application variable in asp.net?
How can we register exception filter globally?