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

Can you create a synonym without having a table?

1042


What is where clause in oracle?

1031


How to insert a record into a table?

1070


What is Trigger in Oracle?

1172


What is a relational database management system?

1120


How many data types are supported?

1079


How to create a temporary table in oracle?

1270


WHAT IS ecc 6.0

2147


How to define a procedure inside another procedure?

1024


How to create a testing table in oracle?

990


What is the data type of dual table?

995


How to delete a column in an existing table?

1076


What is a procedure in oracle?

1199


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1973


Whether any commands are used for months calculation? If so, what are they?

1097