Need an help for SQL query
I need some quick help in for my BI Report which is for Payroll module. I have a report which should return all personal payment method details irrespective of ACTIVE or INACTIVE persons and Accounts associated with them. But the report output is not as expected. I have attached my SQL query. Any suggestions will be much appreciated.