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 are joins..how many types of joins are there?

Answer Posted / guruswamy

join is combaining two or more tables.
there are three types.they are
1).simple join
2).self join
3).3.outer joins

Is This Answer Correct ?    15 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to display employee records who gets more salary than the average salary in the department?

1065


What is the sid in oracle?

961


Differentiate between translate and replace?

1109


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2179


What happens if the imported table already exists?

1030


How to export data to a csv file?

1296


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1067


Is postgres faster than oracle?

1024


What is oracle update statement with inner join ?

1055


What is the dynamic sql in oracle?

1069


What privilege is needed for a user to connect to oracle server?

987


How to define an anonymous procedure without variables?

1098


How do we represent comments in oracle?

1046


what are the default admin accounts in Oracle 10g ?

964


What is a nested table?

1055