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

What are the ways to sending the data in ASP.NET page?

1177


What are the different session state management options available in asp.net?

1040


What is difference between inproc and outproc?

1187


How to make sure that contents of an updatepanel update only when a partial postback takes place (and not on a full postback)?

1029


What is a session in programming?

1143


What is inproc mode in session?

978


What is the difference between a multi-layer and multi-tier applications?

1058


What is difference between cache and session?

1019


How many types of sessions in asp.net?

1159


What is enableviewstate in asp net?

998


Where the assembly is stored in asp.net?

1056


Is global asax mandatory?

1038


Explain the steps to be followed to use passport authentication.

1085


explain code with datachaching with example

2205


What is a server farm in iis?

1084