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

Differentiate between file-based dependency and key-based dependency.

0 Answers  

when using windows API in .net then it is managed code or Unmanaged code?

2 Answers  

Explain serialization and deserialization?

0 Answers  

How do we access view state value of this page in the next page?

0 Answers   MindCracker,

What’s the difference between asp.net web forms and asp.net mvc?

0 Answers  




How can we access static variable?

0 Answers  

What are Session states available and its Uses?

0 Answers   CTS, iLogic,

What is asynchronous call?

0 Answers  

If you are using components in your application, how can you handle exceptions raised in a component?

0 Answers   Accenture,

What are the cookies types in asp.net?

0 Answers  

What is the difference between web config and machine config files?

0 Answers  

What is Web API?

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories