How To Compare Field Values Between Tables
Read Time:24 Sec
I used the following SQL to compare the difference between the F9200 (Data Dictionary) used for EnterpriseOne 9.1 and the one used for EnterpriseOne 8.12 that I copied to the SQL Server using R98403:
SELECT a.FRDTAI,a.FRCDEC AS a_FRCDEC, b.FRCDEC AS b_FRCDEC FROM JDE910.DD910.F9210 a INNER JOIN DD812.PRODDTA.F9210 b ON (a.FRDTAI COLLATE DATABASE_DEFAULT = b.FRDTAI COLLATE DATABASE_DEFAULT) WHERE a.FRCDEC COLLATE DATABASE_DEFAULT b.FRCDEC COLLATE DATABASE_DEFAULT
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Average Rating