What is the difference of a LEFT JOIN and an INNER JOIN statement? What is a Ca

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

Question Posted / meenu

1 Answers
4051 Views
Syntax Softtech, I also Faced
E-Mail Answers

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

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

Write a code for passing ArrayList in Web API?

0 Answers

Is There any Third party tools are using in .Net Technologies? Can u Explain?

4 Answers HCL,

How can we access static variable?

0 Answers

What is the difference between session and application?