AnsweredAssumed Answered

Error Joining Tables

Question asked by Brando on Jul 22, 2019
Latest reply on Aug 5, 2019 by Jouni

Hello,

 

I created 2 tables using the NuGreen Database that I want to Join.

  • EquipmentKPI
  • PlantKPI

EquipmentKPI has the column "Value" which is the name of the Plant Location (e.g. Houston, Little Rock, Etc...)

PlantKPI has the column "Name" which is the same as "Value" for EquipmentKPI

 

I made the following query INNER JOIN and OUTER JOIN queries (See Screenshot Below) and a few variations and receive the following error message (See Screenshot Below).

 

 

Please Advise.

Outcomes