1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

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

Question Posted / meenu


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

Is it possible to add aspx.vb file in to C# Web Project? If so how can i use the vb file in the C# Web project?

3 Answers  

Is sql backend or frontend?

0 Answers  

Describe in brief .net framework and its components.

0 Answers  

What is asp.net mvc? : asp.net mvc

0 Answers  

how can u display multi language (i.e english,spanish...) web site?

2 Answers  




How do you implement sql caching in asp.net?

0 Answers  

what is the purpose of update panel control in ajax?

2 Answers   CSC,

What is session management in web application?

0 Answers  

How .net CLR works with n-tier application

4 Answers   HCL, Hughes,

How does asp.net work?

0 Answers  

What is ipostback?

0 Answers  

What is the differences between a primary key and a unique key in sql server?

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories