Hanu
Answered On : Jul 27th, 2005
Correlated sub query is one of the best example to be used in the sub queries to join the tables. We may be having equi, non-equi, outer joins, however when we talk about joins in the sub queries,correlated is best suited example.
Login to rate this answer.
Edwin Peterson.A
Answered On : Jan 19th, 2006
Let me explain about outer join
see we r having 2 tables called A, B
A has 2 columns
Name No
AA 01
BB 02
CC 03
III ly
B has 2 columns
Name No
AA 01
BB 02
DD 04
result in left outerjoin from A to B
AA 01 01
bb 02 02
cc 03 null
Full outer join from A to B
AA 01 01
BB 02 02
CC 03 null
DD null 04
equijoin(inner join), cartisian join, self join,non-equi join are related to the operators and depend upon the tables.
Subqueries
types
simple subquery, nested subquery, corelated subquery
- every sub query has nested select statement(depentent upon the table)
- u supposed to include in between select statement 'in,any,all'
this is infor about join and subquery,
My contact id is 'edwinpeterson_peace@yahoo.co.in'
Please feel free to ask me d2k and oracle and remedy and install shield 11.5, sql server 2000 and jdeveloper10g.

3 Users have rated as useful.
Login to rate this answer.
sireesha
Answered On : Apr 7th, 2006
Please let me know various joins available and description for every join
Regards,
sireesha
Login to rate this answer.
Two join conidtion we can use for subqueries:
Equi Join,
Self Join
Login to rate this answer.
There are 5 types of joins. Those are
1. Equi Join / Inner Join
2. Non-Equi Join
3. Outer Join ( Left Outer Join, Right Outer Join, Full Outer Join )
4. Self Join
5. Cross Join
Login to rate this answer.