Lets assume we have two arbitrary tables, each loaded independently. Both tables use the NoConcatenate statement and Resident load, because some data wrangling is happening. Yet, both tables do share one field name in common, which I want to use to concatenate / join one table to the other.
How can I merge the first table with the other using either a concatenate or join statement? I find it quite confusing figuring it out compared to other languages as Python, R etc. where I can easily specify the dataframes and the key to use to merge rows.