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

Types of caching. How to implement caching?

2 Answers   Microsoft,


Define secured sockets layer.

0 Answers  


What are the Types of session management in ASP.NET

0 Answers   Microsoft,


Define web services in asp.net.

0 Answers  


What are the different types of sessions in asp.net? Name them?

0 Answers  


How can we make sure that Web API returns JSON data only?

0 Answers  


How many types of web application ?

1 Answers  


What is the use of autowireup in asp.net?

0 Answers  


What's the advantage of using System.Text.StringBuilder over System.String?

3 Answers   IBM, IdeaLake, Infosys,


Do ASP.NET forms authentication cookies provide any protection against replay attacks? Do they, for example, include the client's IP address or anything else that would distinguish the real client from an attacker?

1 Answers  


How to disable cut, copy and paste in TextBox using jQuery in asp.net?

0 Answers   HCL,


What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?

3 Answers   Satyam,


Categories