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.