| Subject | Re: [firebird-support] Finding the differences |
|---|---|
| Author | Virna Constantin |
| Post date | 2011-12-24T03:19:10Z |
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]
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]