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 an oracle tablespace?

1049


How to use subqueries with the in operator using oracle?

1092


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5414


What are the differences between char and varchar2 in oracle?

1177


Explain how are indexes update?

1071


How to see the table columns used in an index?

1024


How do we represent comments in oracle?

1057


How to grant create session privilege to a user in oracle?

1005


What is a nested table and how is it different from a normal table?

1057


What are transaction isolation levels supported by oracle?

1075


How to change system global area (sga) in oracle?

1014


What is redo log?

1071


Is oracle a language?

953


How to define an anonymous block?

1162


Design database draw er diagram for a certain scenario ?

4580