Re: inner outer joins

[Chris]

Brian E Boothe wrote:
> hi all
> Can someone provide a small project using inner and outter joins with
> querys thanks alot

create table t1 (id int);
create table t2 (id int);

This will find everything that has an entry in both tables:
select * from t1 inner join t2;

This will find records that are in t1 but not t2:
select * from t1 left outer join t2 where t2.id is null;

Read the manual for more information.