What are various joins used while writing SUBQUERIES?

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.

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.

  

Please let me know various joins available and description for every join

Regards,

sireesha

Two join conidtion we can use for subqueries:
Equi Join,
Self Join

    
    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