Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32997 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pardeep chadha
Majorly subqueries run independently and result of the
subquery used in the outer query(other than corelated subquery).
And in case of join a query only give the result when the
joining condition gets satisfied.
| Is This Answer Correct ? | 32 Yes | 11 No |
Answer / anbu
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 ? | 17 Yes | 4 No |
Answer / mythili
Join:
It is the method of joining one or more tables together and
finding a answer.
Sub Query:
It is a method of finding one answer using another query.
Main Difference:
In join both the tables should have a comman column name
but in subquery without having a column name we can execute
the query.
| Is This Answer Correct ? | 30 Yes | 19 No |
Answer / siva
Sub Query:
The Sub Query only get the results as one table or the
other table based that the result be of onther table as
used in the table.
The two tables information are dispalyed as combiend.
Join:
To get results more rhan two tables information.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / adil khan
main difference between join and subqurey is that join is
used for known condition while subquery is used for unknown
condition.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / affan
the main diff is
the subquery gives the result from one table only,but whose condition may depend on another table i.e the inner query.
whereas join gives the result from both the tables if condition is satisfied
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / kuldeep singh
Join:
It is the machanism of joining one or more tables together
and finding information from one or all tables used in join.
Sub Query:
It is a method of finding answer using another query as
parametere for first query.
Main Difference:
In join both the tables should have a comman column type
but in subquery without having a column type we can execute
the query.
| Is This Answer Correct ? | 17 Yes | 16 No |
Answer / srijina
join combines tables and retrieves data where as sub query
doesn't combines two table.join is more faster than subquery
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / suramya biswas
Sub Query can be used for UPDATE,DELETE statements where as
Join Query is only used in SELECT statement
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the attributes that are found in a cursor?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
How to use "while" statements in oracle?
What is SQL Tuning Advisor in Oracle?
What is Water Mark in Oracle?
What do you mean by a database transaction & what all tcl statements are available in oracle?
what is reindexing?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
write a query that displays every Friday in a year with date?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is oracle open database communication (odbc)?
Oracle General 
