Differences between Inner join and outer join

[Former Member]

Please any one tell what are the differences between Inner join and Outer join plz tell me

points will be rewarded

[Former Member]

hi

i will just tell u very basic difference between inner join and outer join..

in inner join only those entries are shown which are in both the tables.. like if join is on field 'name'. then only those entries will be shown in join table which are in both the tables..

where as in outer join all the entries of both the tables will be shown.. like if there in some X value in table A and table B doesnt have X then also it will be shown in join table.. the only thing will be values corresponding to y table will bne null at that time..

i hope it helped

give rewards if helpful

take care

palak