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

Explain the importance of .pll extension in oracle?

958


How can I see all tables in oracle?

959


Is the After report trigger fired if the report execution fails ?

2879


How to drop a tablespace?

995


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2071


How to start an oracle instance?

959


How to rename a column in an existing table?

981


What is an external table?

963


Can group functions be mixed with non-group selection fields?

969


How to sort the query output in oracle?

976


What is the usage of merge statement?

1099


How does oracle handle read consistency?

1054


What is an oracle data file?

1047


How to create tables for odbc connection testing?

1022


How to put more than 1000 values into an oracle in clause?

979