RE: Difference between inner join and join in SQL query

I believe you are correct.
For some join samples try the following.

create table qtemp.t1 (
col_a char(1),
col_b char(5))
;
create table qtemp.t2 (
col_a char(1),
col_c char(10))
;
insert into qtemp.t1 values('A', 'x1');
insert into qtemp.t1 values('B', 'x2');
insert into qtemp.t2 values('B', 'x3');
insert into qtemp.t2 values('C', 'x4');

select t1.*, t2.*
from qtemp.t1 join qtemp.t2 on t1.col_a = t2.col_a;
select t1.*, t2.*
from qtemp.t1 inner join qtemp.t2 on t1.col_a = t2.col_a;
select t1.*, t2.*
from qtemp.t1 left outer join qtemp.t2 on t1.col_a = t2.col_a;
select t1.*, t2.*
from qtemp.t1 right outer join qtemp.t2 on t1.col_a = t2.col_a;
select t1.*, t2.*
from qtemp.t1 left exception join qtemp.t2 on t1.col_a = t2.col_a;
select t1.*, t2.*
from qtemp.t1 right exception join qtemp.t2 on t1.col_a = t2.col_a;
select t1.*, t2.*
from qtemp.t1 full outer join qtemp.t2 on t1.col_a = t2.col_a;

Rob Berendt