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 is better asp.net or php?

1024


How long the items in ViewState exists?

1437


Which protocol is used in a web api?

1091


What is the difference between user control and custom control?

937


Which is better session or viewstate?

946


Explain About duration in caching technique

1057


What is redirecting behavior?

957


What is a nested masterpage in asp.net 2.0? Can there be a master page inside a masterpage?

886


Explain server side state management system.

956


What is a server cookie?

998


Explain Areas in MVC?

1088


What is the basic purpose of the required field validator? How can you use a required field validator to check that the user changes the initial value of a text box? a listbox?

1876


How do you secure your configuration files to be accessed remotely by unauthorized users?

1104


Explain the server control events of asp.net ?

992


Fetch one page value to another page without using state-managment ?

893