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


Please Help Members By Posting Answers For Below Questions

Define web.config in .net?

825


How will create assesblies at run time?

739


How does a content page differ from a master page?

707


Explain global assembly cache.

764


What is x xss protection?

732


Write a code for sending an email from asp.net application.

756


Why should i prefer JSP over asp.net or any other web development language..??

1695


What is rending process in ASP.NET?

814


What is validation in asp.net?

759


where can i gather the materials for MCP certification

4826


How to register exception filter globally?

785


What is the adavantage of using ASP.NET routing?

858


Explain the difference between an exe and a dll?

704


What is difference between session and application in asp net?

720


Distinguish between Server-side and Client-side code?

751