General information
Category:
Coding, syntax & commands
>>Is there a SQL way of asking if a record in table 1 does not have a match in table 2?
>>
>>
>>TIA
>>
>>Chris
>
>select a.key, b.key, ;
>isnull(a.key) as 'NotInOld', ;
>isnull(b.key) as 'NotInNew' ;
> from old a full join new b on a.key=b.key
>
>Cetin
select a.grade,a.titlecode,a.cocode,b.grade,b.titlecode, ;
isnull(a.titlecode) as 'notinold' ;
from c:\sys2data\tlkpttlgrade a full join c:\sys2data\tlkpttlgrade.old b ;
on a.titlecode = b.titlecode and a.cocode = b.cocode ;
where (a.titlecode = b.titlecode) and (a.cocode = b.cocode) and (a.grade <> b.grade) ;
into table c:\sys2data\tblttlgradechanges4
there is a record in b that has a cocode that exists in a but a titlecode.
It does not get selected by the logic?
Chris
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only