Hi @MasterOfLogic;
If you are interested in inner, full or left join, you can use Join DataTable
activity and that will allow you to choose the input datatable and add conditions as required.
If you are wondering how to perform right joins. This is not available by default. You can refer to my post in this thread to perform Right Join two datatables in UiPath. How to remove duplicates in merge data table to get unique values? - Build - UiPath Community Forum