I think you need to create a data item named "CJ" in both tables with the value 1. Then both tables will have a common value to join them. Of course, since the common item is manufactured the relationship will be many-to-many.. It's not clear if you need to join them using site number which could be a common field
------------------------------
Mauro Santos Otero
------------------------------
Original Message:
Sent: Thu February 11, 2021 05:36 PM
From: Jim Denton
Subject: Want to join 2 tables that have no common unique indexes
Hi all,
I want to join 2 tables that have no common/unique indexes. They do both have the field/column "site number", but they both have multiple of the same site numbers. Do I perhaps need to create a 3rd table with just the "site number" with unique site numbers and do a 1-to-many to both of the other tables which I think would be a many-to-many?
Jim
------------------------------
Jim Denton
------------------------------
#CognosAnalyticswithWatson