What is the difference of a LEFT JOIN and an INNER JOIN
statement? What is a Cartesian product? What causes it?
- 1 Answers
- 4192 Views
- Syntax Softtech, I also Faced
- E-Mail Answers
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 are the benefits of view state?
Which is the parent class of the web server control?
What is an il?
Explain the differences between managed and unmanaged code?
What is a ashx file?
What are the various session state management options provided by asp.net?
In a webservice, need to display 10 rows from a table. Which is the best choice among datareader or dataset?
What is data cache in sql server?
What is aspect-oriented programming?
How is application management and maintenance improved in asp.net 2.0?
How to Insert/Add in ASPXgridview
What is the importance of aspnet_isapi.dll, inetinfo.exe andaspnet_wp.exe in the page loading process.
Who is using asp.net?
Explain security types in asp.net?
Why session is more secure than cookies?
