Hi All,
I have an SQL queries that will list all the employees with their job(s) and pay rate.
select
e.obj_num as "Payroll ID",
e.long_first_name as "First Name" ,
e.long_last_name as "Last Name" ,
j.name as "Job Name" ,
COALESCE(h.override_reg_pay_rate, j.deflt_reg_pay_rate) as 'Pay...