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 are oracle functions?

1037


Give the constructs of a package, function or a procedure.

1060


What is oracle latest version?

1103


How can windows applications connect to oracle servers?

1064


What is oracle database client?

1039


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2141


how to make an oracle object

2366


What are the different types of failures that occur in Oracle database?

1072


What is Reduced List of Values?

2181


What is the usage of control file in oracle?

1094


HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2503


How to start your 10g xe server?

1049


How to use subqueries with the exists operator in oracle?

1033


Write a trigger example in oracle?

1072


How to use existing values in update statements using oracle?

1074