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 websites use asp.net?

1066


What is smpte vc-1?

1085


What are the parts of an http response?

1017


What are the different types of events are occured when a client requests an ASP.NET page from IIS server?

1167


What is the significance of attaching a profile while creating a user?

1101


What is server side session management?

977


What is the difference between “Web.config” and “Machine.Config”?

1180


What do you mean by serialize and marshalbyref?

1054


How many types of state management are there in asp net?

1067


What is state management react?

1082


When cookie will expire?

1045


What is the difference between asp.net and mvc?

1160


Can we have multiple master pages in asp net?

1029


What is Web Server Control Templates.?

1104


What is windows active directory authentication?

1102