Hello raymond,
usually you join two tables by focusing on reference fields.
For example, if you want to join incident and problem, you can do it by using the "problem" field on the incident table.
Consider incident prefix as "inc" and problem prefix as "prb".
You would join the in this way:
inc_problem = prb.sys_id
This would join both tables based on that field.
I'm not sure exactly what you want to achieve, but with this you have now an idea on how to do it.
Hope this helps!
Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!
Best Regards,
Filipe Cruz
