Forum Discussion

cs2o's avatar
cs2o
Regular Visitor
4 years ago
Solved

Data manipulation; connecting reference columns then pivoting?

Every SITE has multiple SYSTEMS with the same set of COMMON NAMES. This is where I lose my E&R, ITEM REF belongs to a single SITE that I could extract from the SQL output, but I'm not sure how to con...
  • cs2o's avatar
    4 years ago

    Turns out what I needed to do was merge these queries, not create a relationship.