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
What's the use of formatters in .net?
How to add DateTime Control in normal DataGrid Server Control?
Explain the various authentication mechanisms in asp.net.
What is web api config?
What is asp.net? How is it different from asp?
How does viewstate work?
What is asp.net ajax?
What is difference between datalist and gridview?
How could you modify xaml content from javascript?
What are the advantages of using Master Pages?
What is postback and autopostback in asp.net?
Explain what benefit does your code receive if you decorate it with attributes demanding specific security permissions?
Why is mvc better than asp.net?
How does session work?
How can u debug your .net application?