hi, people how can i retriev prd_offering.prd_offering_name, joining from account?, i don't see a clear way.
i am building this report: select account.created_date, customer.display_name,global_account_num,account.external_id,account_state.status_description,office.display_name,of.display_name from account join account_state on account.account_state_id = account_state.account_state_id join customer on account.customer_id = customer.customer_id join office on account.office_id = office.office_id join office of on office.parent_office_id = of.office_id but i need to include prd_offering.prd_offering_name. thanks in advance. ------------------------------------------------------------------------------ _______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
