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?



What is the difference of a LEFT JOIN and an INNER JOIN statement? What is a Cartesian product? Wha..

Answer / 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

More ASP.NET Interview Questions

All kind of access specifiers for a class and for methods ?

1 Answers   MMTS,


How to authenticate users using Web.Config ?

1 Answers   Accenture,


Why do we need Sessions?

0 Answers   QuestPond,


What is caching? Explain.

0 Answers  


Why do we use sessions?

0 Answers  


What is personalization? What are the properties available in personalization?

1 Answers  


What is globalization and localization in asp net?

0 Answers  


Can the validation occurs in server-side or client-side? If the validation occurs why should we do?

0 Answers   Siebel,


Where can I get the details on migration of existing projects using various technologies to asp.net?

0 Answers  


Define Query Interface,Adref,Release?

1 Answers   Microsoft,


Differentiate between authentication and authorization.

0 Answers  


Differentiate globalization and localization.

0 Answers  


Categories