Untitled

select
abi.accountid as account_identificator,
created_by.name as created_by,
abi.createdon + interval '3 hour' as created_on,
modified_by.name as modified_by,
abi.modifiedon + interval '3 hour' as modified_on,
abi.smaccountcorrespondent as account_correspondent,
abi.smaccountpayment as account_payment,
abi.smbankbik as bank_bik,
abi.smbankkpp as bank_kpp,
abi.smbankname as bank_name,
abi.smexternalcode as external_code,
abi.smismain as is_main,
abi.id as identificator,
abi.smisoutdated as is_outdated
from vw_ods_bpm_soft.vw_accountbillinginfo abi
left join vw_ods_bpm_soft.vw_contact created_by
    on created_by.id = abi."createdbyid"
left join vw_ods_bpm_soft.vw_contact modified_by
    on modified_by.id = abi.modifiedbyid;