Heres the Query
select * from TableOne A,TableTwo B where A.CourseID<>B.CourseID and
----- Original Message -----
To: sql language <sql_language@p...>
Sent: Saturday, December 23, 2000 2:16 PM
Subject: [sql_language] Finding records one table but not in the other one
> I have two tables, TableOne and TableTwo, both having the same structure.
> Each table has only two fields course_code, course_version.
> How do I select records in TableOne which have course_code + course
> version different from those in TableTwo?
> My goal is to add any new courses ( idenified by new course_code or new
> course_version ) appearing in TableOne into TableTwo.
> Wilson Li
> Monash University
You are currently subscribed to sql_language as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-sql_language-$subst('Recip.MemberIDChar')@p2p.wrox.com