|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.
|• inner outer joins||Brian E Boothe||9 Aug|
|• Re: inner outer joins||Chris||11 Aug|