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 websites use asp.net?
What is smpte vc-1?
What are the parts of an http response?
What are the different types of events are occured when a client requests an ASP.NET page from IIS server?
What is the significance of attaching a profile while creating a user?
What is server side session management?
What is the difference between “Web.config” and “Machine.Config”?
What do you mean by serialize and marshalbyref?
How many types of state management are there in asp net?
What is state management react?
When cookie will expire?
What is the difference between asp.net and mvc?
Can we have multiple master pages in asp net?
What is Web Server Control Templates.?
What is windows active directory authentication?