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

What is the typical session identifier?

0 Answers

How dataadapter.fill works?

0 Answers

Which is the best institute to learn Microsoft Technologies and the faculty if you Know?

0 Answers TCS,

Give me one example of Web API Routing?

0 Answers

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

Is session stored in browser?

0 Answers

You create an assembly to access data in a relational database. This assembly will be used by several ASP.NET applications on your Web server. You need to ensure that all your applications can access the assembly. Which two actions should you take (Each Answer: presents part of the solution.)? (Choose two) A . Run the Assembly Registration tool (Regasm.exe). B . Run the String Name tool (Sn.exe). C . Run the Installer tool (Intallutil.exe). D . Run the Global Assembly Cache tool (Gacutil.exe).

6 Answers CPCL, Syntax Softtech,

What are the advantages and disadvantages of Using Cookies?

0 Answers MCN Solutions,

After capturing the SelectIndexChanged event for a ListBox Control, you find that the event handler doesn?t execute. What could be the problem be? a) The AutoEventWireup attribute is set to False b) The AutomaticPostBack attribute is set to False c) The codebehind module is not properly compiled d) The ListBox must be defined WithEvents.

2 Answers Syntax Softtech,

How to consume a webservice in a windows application without adding through the web reference?

1 Answers 247Customer,

How to implement Authentication and Authorization?

0 Answers QuestPond,

What is session authentication?

0 Answers

For more ASP.NET Interview Questions Click Here