Untitled

select
createdbyid.name as created_by,
saib.createdon + interval '3 hour' as created_on,
modifiedbyid.name as modified_by,
saib.modifiedon + interval '3 hour' as modified_on,
saib.smaccountid as account_identificator,
saib.smbrandid as brand_identificator,
saib.smaccountbillinginfoid as account_billing_info_identificator
from vw_ods_bpm_soft.vw_smaccountinbrand saib
left join vw_ods_bpm_soft.vw_contact createdbyid
    on createdbyid.id  = saib.createdbyid
left join vw_ods_bpm_soft.vw_contact modifiedbyid
    on modifiedbyid.id = saib.modifiedbyid;