I need to make a table for a detailed report that shows all the transactions each employee has done. I need to use information from 2 tables "payment" has the "staff_id" and "amount" fields. The "staff" table has "staff_id", "first_name", "last_name", and "active". The last of which tells if the employee is active or not. I need a table that has the staff_id, first name, last name and active status on each row. How do I go about doing this in SQL?