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

their should be a relationship between the tables then only
we can use join conditions....
But the subquery can be used to retrive data from one or
more table if their is no relation between the tables....

Is This Answer Correct ?    78 Yes 27 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by group by clause?

1092


How to connect to a remote server?

1187


Why is oracle so popular?

1053


How to speed up webrick?

1122


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2183


How to pass a parameter to a cursor in oracle?

1229


How to create a stored function in oracle?

1156


How to unlock the sample user account in oracle?

1076


What are the set operators union, union all, minus & intersect meant to do?

1027


What is the data pump export utility?

1130


What is instant client oracle?

1072


What is index-organized table in Oracle?

1118


Can we protect our pl/sql source code?

1082


What is a database schema in oracle?

1150


What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4680