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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]