Cheers I will check it out :-)

Si

On 24 December 2011 03:19, Virna Constantin <costel_61@...> wrote:

> **
>
>
> SELECT S.*,M.col3 as col3m
> FROM SECND S
> inner join MASTER M on S.COL1=M.col1 and S.COL2=M.COL2
> where S.COL3<>M.COL3
>
> ________________________________
> In the example above the last record in secondary table is different so
> this is the only row I would like to return, if that makes sense.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]