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
4734 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

How to store a dataset in a viewstate?

3 Answers Patni,

Explain what is an assembly?

0 Answers

version information of assembly consist of _________ values.

3 Answers AG Technologies,

What is the difference between and ActiveX dll and control?

2 Answers Microsoft,

Explain client side state management system.

0 Answers

Which color scheme in a Repeater control can you provide alternatively?

1 Answers Siebel,

How will you load dynamic assembly? How will create assesblies at run time?

0 Answers

How does output caching work in ASP.NET?

0 Answers

On what object is the transaction in ADO.NET focused on? a) The command object b) The DataSet object c) The Connection object d) The DataAdapter object

4 Answers Syntax Softtech,

differences between class inheritance and interface?

2 Answers

Where would you use an ihttpmodule, and what are the limitations of any?

0 Answers

What is the difference between a page theme and a global theme?

0 Answers

For more ASP.NET Interview Questions Click Here