Hi everyone, I am a beginner in terms of SQL development, please be kind to me
I am building a tagging system for my application. The first table is storing the tags assigned by my team (human reviewer), while the second table is storing the tags assigned automatically by my application (by scanning the text during data import). Here are the two tables to illustrate:
Table 1. Human-reviewer Tags
Table 2. Machine-assisted Tags
| ID_RECORD | TAG |
|---|
| 1 | helo |
| 2 | wor |
| 3 | foo |
On the reporting side, I want to display all records, with each record displays Human-reviewer tags if it exist. If the record has not been reviewed by the human, it will take the tags from the Machine-assisted tags (because it is guaranteed that all records are automatically assigned tags by the tool, but my team need longer time to review and assign tags to the records).
How can I achieve this with SQL? I am using OracleDB v12.
Thank you in advance