I’m trying to show the results of a query in a table using information from different tables.
Table A columns: id, state
Table B columns: id, batch_id, state
Table A Records:
1 - Batch Ready
2 - Batch Completed
3 - Bad Batch
When a batch is created a new record is placed into table C, under the state column we are putting the id number that matches the current state (encase the description changes).
Then we show table C and do some filtering based on the states and other things, the only problem is that nobody can remember what the state numbers mean.
Is there a way to pull the state description from table A and replace the id value with the states description text? and show that to the operator