Sign Up Login


  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 overloading possible in web services?

2 Answers   Microsoft,

What are the types of session in asp.net?

0 Answers  

what are Httpmodule and HttpHandler?

3 Answers   Microsoft, Wipro,

i wand basic interview based questions in asp.net and vb.net

0 Answers   Legio Infotech,

why we are using delegates and in which condition it is required?

3 Answers   TCS,

What are session variables?

2 Answers   Microsoft,

what are the different ASP.NET Application Folders?

1 Answers   Wipro,

what is use of doctype tag in asp.net

1 Answers   TCS, Wipro,

What's the use of response.output.write()?

0 Answers  

What is SQL injection?

2 Answers  

what is the challenging situation you faced in your career?

3 Answers   Calsoft, HP, Satyam, Wipro,

What is the difference between login controls and forms authentication?

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories