What is the difference of a LEFT JOIN and an INNER JOIN
statement? What is a Cartesian product? What causes it?



What is the difference of a LEFT JOIN and an INNER JOIN statement? What is a Cartesian product? Wha..

Answer / 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

More ASP.NET Interview Questions

How .net CLR works with n-tier application

4 Answers   HCL, Hughes,


What is dataset and uses of dataset ?

6 Answers   HCL, TCS,


How long does an http session last?

0 Answers  


How connect data into DropDownList from Aceess Table?

1 Answers   HCL, TCS,


what is caching?

4 Answers   Microsoft,


What is the use of The Page.Master Property?

1 Answers  


Can you use Web API with ASP.NET Web Form?

0 Answers  


Why is global asax is used?

0 Answers  


Explain a program using razor view engine to create a simple application? : asp.net mvc

0 Answers  


How can we prevent an aspx page get refreshed when any information fetch from the database ?

2 Answers   Minecode,


What are the different types of proxy patterns?

0 Answers  


You are planning the deployment of an ASP.NET application. The application uses a Visual Studio .NET component named DataAccess that will be shared with other applications on your Web server. You are using Visual Studio .NET to create a Windows Installer package. You need to deploy DataAccess and the ASP.NET application so that they can be uninstalled later of necessary. What should you do? A . Create a setup project for DataAccess. Add the ASP.NET application in a custom action. B . Create a setup project for the ASP.NET application. Create another setup project for DataAccess. C . Create a Web setup project for the ASP.NET application. Add a project output for DataAccess. D . Create a Web setup project for the ASP.NET application. Add a merge module for DataAccess.

3 Answers   Syntax Softtech,


Categories