How to Compare and return with inconsistent field as results

[kentck86]

Hi Guys,

I wanted to make a queries that could do the following to compare data field between Data Table No.1 & Data Table No.2 and then it will return with the results of Inconsistent Field ONLY as a New Table.

Data Table No.1

RncId	version	N302	N304	N308	T313	T314	ipAddress
205	RN7.0	7	2	2	3	5	10.233.18.3
206	RN7.0	7	2	2	3	5	10.233.18.67
207	RN7.0	7	2	2	3	5	10.233.18.131
208	RN7.0	7	2	2	3	5	10.233.19.3
404	RN7.0	7	2	2	3	5	10.233.70.3

Data Table No.2

RncId	version	N302	N304	N308	T313	T314	ipAddress
205	RN7.0	7	2	2	3	5	10.233.18.3
206	RN7.0	7	2	2	3	5	10.233.18.67
207	RN9.0	8	4	3	4	6	10.233.18.131
208	RN7.0	7	2	2	3	5	10.233.19.3
404	RN7.0	7	2	2	3	5	10.233.70.3

Results Table:

RncId	version	N302	N304	N308	T313	T314	ipAddress
207	RN7.0 Change RN9.0	7 Change 8	2 Change 4	2 Change 3	3 Change 4	5 Change 6

[ranman256]

queries are not Inconsistent, they will always be consistent in the result.
not sure what you mean.
do you mean , show the changes between tabl1 and 2?

in a query join the common field.
compare each field,
iif(fld1.n302<> tbl2.n302, "change","")

[kentck86]

queries are not Inconsistent, they will always be consistent in the result.
not sure what you mean.
do you mean , show the changes between tabl1 and 2?

in a query join the common field.
compare each field,
iif(fld1.n302<> tbl2.n302, "change","")

Hi ranman,

Yes, i wanted to shows changes between table 1 and table 2 ONLY. Those without changes it should not shows results.

thank you

[CJ_London]

Try

SELECT Table1.RncID, Table1.version & " Change " & table2.version AS VersionChange, Table1.N302 & " Change " & table2.N302 AS N302Change,....
FROM Table1 INNER JOIN Table2 ON Table1.RncID=Table2.RncID
WHERE (table1.version<>table2.version) OR (table1.N302<>table2.N302) OR....

you can complete the dots for the other fields