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

Difference between join and a subquery?

Answer Posted / kiran

subquery can be used for simple logical queries , to get
required output/condition

but if you want to compare two or more tables and get output
in the way you want it would be lot difficult to manage all
those with subqueries - so we can use the concept of joins

Is This Answer Correct ?    39 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create id with auto_increment on oracle?

990


What is Reduced List of Values?

2169


How to view the data files in the current database?

1098


How to use windows user to connect to the server?

990


what is Single Byte Overhead...?

2559


What is the string concatenation operator in oracle?

1177


Explain the use of tables option in exp command.

1117


What is a read write transaction in oracle?

1093


What is the scope of a local variable?

1067


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

1093


How to create a table interactively?

1097


What is bulk collect in oracle?

999


How can I combine multiple rows into a comma-delimited list in oracle?

1062


Give the various rollback segment states.

1052


Can you have more than one content canvas view attached with a window ?

2333