I have tables A and B from an old system and tables D and E from a new system. They both use table C.
I already show the old name (C.NAME). How can I get this SQL (using SPUFI) to also show then new name (C2.NAME)?
SELECT A.CONTRACT, -- OLD CONTRACT
C.NAME -- OLD NAME
FROM TABLEA A,
AND A.CONTRACT IN(
FROM TABLED D,
AND C.NAME ^= C2.NAME) -- OLD NAME DOES NOT MATCH NEW NAME