Joining condition for ap_invoices_all and exm_expense_reports
I am unable to find the approver name when i am doing joining for below query:
but i am unable to get the approver name when i am giving joining for ap_invoices table. Without taking invoice table i am getting the approver name.
and is invoice_num and expense_report_num is same?
can you please help me to get the issue resolved.
Thanks in advance,