List:General Discussion« Previous MessageNext Message »
From:Chris Date:August 11 2006 2:33am
Subject:Re: inner outer joins
View as plain text  
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.
Thread
inner outer joinsBrian E Boothe9 Aug
  • Re: inner outer joinsChris11 Aug