Is there a way to add another column to a table with a dataset from a transaction group?
I want to match the code from the first column to text that I would put in the added column.
The text associated with the code number is not in my transaction group.
Like if I know 2101 means the part is too small, and I want my table to also show the reason.
Your DB tool of choice (Management Studio, Workbench, DataGrip, et al) is fine. This, generally speaking, would be a static table, once all your codes are in.