Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Which property needs to be set for script manager control to extend the time before throwing time out expection if no response is received from the server?

921


Write the different features of a Thread and a Process?

1092


Using code explain Configuration Management

1905


What is difference between rest and soap?

1055


Is asp.net different from asp? If yes, explain how?

978


What is a viewstate?

940


What do you mean by authentication?

1030


What is meant by ispostback in asp net?

1019


How will you load dynamic assembly? How will create assesblies at run time?

894


What is the difference between asp.net and mvc?

1061


What is sql data source control in asp.net?

1013


Which object is used to encapsulate the state of the client and the browser in ASP.NET?

1050


Can we use MSSql as backend in asp.net...if yes then How.?

1000


What is scope of an application variable in asp.net?

952


How can we register exception filter globally?

955