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
4738 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 create a db connection at one place/page so that we can use that connection for all pages/forms/windows.what r the steps ned to be performed if question not clear,let me know

0 Answers

Can we use a static function with a non-static variable?

0 Answers

Hi, I am a fresher. i have a problem related to DataGrid . i have a data grid and i have to place a dropdown in the datagrid.and i have to retrieve the values from the database (sqlserver).please tell me any idea about the code.

1 Answers Lambent,

Which control would you use if you needed to make sure the values in two different controls matched?

4 Answers Siebel Systems,

What language is asp.net written in?

0 Answers

explain code with multi inhertance

0 Answers

What parameters can you pass in the url of the api? Can get and post use the same url?

0 Answers

Is it possible for me to change my aspx file extension to some other name?

0 Answers

Compare and contrast between inline and code behind - which one is best?