How can I do something like a union with two tables?
Could you somebody help out with this issue:
I have a database with tables Customers, Staff, Appointments, FrontDeskWorkSchedules (please the see relationship in attachment). Basically, there are two kinds of staff: technicians who earns commissions, and receptionists who earn hourly wages. But I need to put their earnings together to form ONE report. How could I do that?
I would appreciate your ideas!