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