First thanks for the concern.
I have 2 tables having the same structure and holding the same information but different field names. The difference between them is the source of the data they hold and of which am interested in the datasource.
I want to be able to know if the 4 key fields in both tables have the same values. If this is true I would insert "both" into a field called "datasource" in one of the table. For example:
Given table A (datasource is server) Table B (datasource is mobile)
two data sources where used to obtain the data for A and B and for A, one datasource gave data for A and B which was separated.
Now I have an extra field in A called datasource. In this field, i would insert "both" if above 4 fields in A and B have same values in date, longitude lat, time (which means both data sources gave same entries) ELSE I would insert " server" which means the datasource is server. Second, I reverse the comparison and this time, Insert into the same column "both" if the values of the 4 key fields match or ELSE INSERT "Mobile" which means the datasource for the table which is the basis of the comparison is the mobile.
So it is like taking TableA (source of data is "server") as main and comparing with B to insert "Both" or "server"
and then taking TableB(source of data is mobile) as main and comparing with A to insert "both" or "mobile".
So at the end I have the extra field which would have either "both", "server" or "mobile" based on the comparison and the reverse comparison of the values of the 4key fields of tableA and Table B
This is what I am trying to do and i hope you understand me if not please ask me where you are not clear and i would be ready to explain. This problem at the main time has stoped me from progressing at all. Please thanks for you assistance ones again.