I need to make a table for a detailed report that shows all the transactions each employee
Fantastic news! We've Found the answer you've been seeking!
Question:
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?
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: