Untitled

 avatar
unknown
sql
a year ago
718 B
6
Indexable
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 "AccountBillingInfo" abi 
left join "Contact" created_by
    on created_by."Id" = abi."CreatedById" 
left join "Contact" modified_by
    on modified_by."Id" = abi."ModifiedById" 
Editor is loading...
Leave a Comment