SELECT e.id, e.expense_date, e.expense_number, e.category, e.vendor, 
            CONCAT(emp.first_name, " ", emp.last_name) as employee_name,
            e.total_amount, e.status, e.receipt_file
     FROM expenses e
     LEFT JOIN users emp ON e.employee_id = emp.id
     WHERE 1=1