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...

Whatz the main diff between Subquery and a Join

Answer Posted / siva

Sub Query:

The Sub Query only get the results as one table or the
other table based that the result be of onther table as
used in the table.
The two tables information are dispalyed as combiend.

Join:

To get results more rhan two tables information.

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is java oracle used for?

1075


How to use "if" statements on multiple conditions?

1217


How to list all indexes in your schema?

1141


How to define an external table with a text file?

1125


How oracle handles dead locks?

1129


How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2440


How to rename an index?

1124


What is a package ? What are the advantages of package ?

1136


What is difference between truncate and delete?

1096


What are the different types of modules in oracle forms?

1047


How to build data dictionary view an new database?

1052


How many types of cluster table in Oracle?

1080


How to rebuild an index in oracle?

1069


How to define an oracle cursor variable?

1092


What is SQL Tuning Advisor in Oracle?

1248