Naming meeting subscribers and commission:
select concat(c.MEB_VA_FIRSTNAME, ' ', c.MEB_VA_LASTNAME) as Com, concat(r.MEB_VA_FIRSTNAME, ' ', r.MEB_VA_LASTNAME) as Reg from DT_MEETINGSUBSCRIPTION ms inner join DT_MESLINK mes on (ms.MES_ID = mes.MES_ID) inner join DT_MEMBER r on (r.MEB_ID = mes.MEB_ID) left outer join DT_MEMBER c on (ms.MEB_ID_COMMISSION = c.MEB_ID);