Field concatenation

Please help I am relatively new to the Power I platform. I have 2 tables, a Device table containing DeviceName, categoryID and other fields. I also have a Category table that contains CategoryName and Description. How can I go about joining the DeviceName values from the the Device table to the CategoryName and Description from the Category table to create a new merged table with the respevtive values.