I have two tables.
Table A has 4 important fields (1, 2, 3, 4)
field1 together with field 2 are unique ID, with field3 is even more unique, field 4 is just important information we want in the result of the query.
Table B with 8 important fields - 1, 2, 3, 4, 5, 6, 7, 8
1, 2, and 3 is unique ....... that matches to 1, 2, and 3 in table A
1, 2, and 4 is unique ....... that matches to 1, 2, and 3 in table A
1, 2, and 5 is unique ....... that matches to 1, 2, and 3 in table A
1, 2, and 6 is unique ....... that matches to 1, 2, and 3 in table A
1, 2, and 7 is unique ....... that matches to 1, 2, and 3 in table A
1, 2, and 8 is unique ....... that matches to 1, 2, and 3 in table A
fields 6,7,8 have some missing data.
I want to join table A with table B to show table A's field 4 for each of table B's field 3, 4, 5, 6, 7, and 8 side by side.
Example:
I want to show table B's field 3 matching table A's field 4 side by side with table B's field 4's matching table A's field 4.
It's hard because there is no join to do this, as there is no same id key from the result of
table B's field 3 matching table A's field 4
to
table B's field 4 matching table A's field 4.
I don't know if this is possible.
Hope this makes sense. If not, I will clear it up.