p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

sql_language thread: Finding records one table but not in the other one


Message #1 by wai.keung.li@a... on Sat, 23 Dec 2000 08:46:40 -0000

Heres the Query
select * from TableOne A,TableTwo B where A.CourseID<>B.CourseID and
A.CourseVersion<>B.CourseVersion





----- Original Message -----
From: <wai.keung.li@a...>
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.
>
> Thanks.
>
> Wilson Li
> Monash University
> Australia
>



---
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

  Return to Index