What is the difference of a LEFT JOIN and an INNER JOIN
statement? What is a Cartesian product? What causes it?
Answer Posted / janardan baghla
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 View All Answers
is there any third party tools are using in .net technologies? what are there ? give me the brief introduction?
Is asp.net and .net same?
Whats the difference between abstract factory pattern and factory pattern?
How to fetch a data from one table to another table in asp.net ?
Explain the asp.net session state modes.
What are the advantages of using Master Pages?
Is asp.net a programming language or framework?
What is difference between session and cookies in asp net?
Explain what is viewstate?
How to set the pane area to transparent of a scrollPane component.?
Explain the differences between clr & cts?
How many types of Cookies are available in ASP.NET?
What are the various session state management options provided by asp.net?
Can we use html in asp.net?
Does web services support data reader like pom project?