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
4647 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 are the layouts of ASP.NET Pages?

0 Answers

Explain how asp.net page works?

0 Answers

What is difference between viewstate and session in asp net?

0 Answers

How Many types of Page Load functions in asp.net

2 Answers

What is the difference between a Thread and Process?

1 Answers

What are strong names?

0 Answers

What are Master pages? How to define a Master page?

3 Answers

Which method do you use to kill explicitly a users session?

0 Answers MindCracker,

How do you design a website with multilingual support in ASP.NET ?

0 Answers MCN Solutions,

RequiredFieldValidator--write code in javascript

3 Answers Wipro,

What are validator? How do you disable them?

0 Answers

Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?

0 Answers Hexaware, Infosys,

For more ASP.NET Interview Questions Click Here