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
Why and where this web.config file is used?
Describe the method to create a permanent cookie?
What are the Types of chaching. How to implement caching
Whats the difference between abstract factory pattern and factory pattern?
Explain about Application and Session Events ?
When maintaining session through sql server, what is the impact of read and write operation on session objects?
What is bound controls
How ASP.NET page works?
What is syntax code to send email from an asp.net application?
Explain what are the advantages of asp.net mvc framework? : asp.net mvc
What symbol specifies the beginning of a query string?
while developing webservices if i want some users to use my webservice only how can i give security to my webservice?
Why do I get error message "could not load type" whenever I browse to my asp.net web site?
What language is asp.net written in?
We are using Jscriopt validations and at clint site javascript is not running that time validation would work? if yes then how it would behave?