Untitled
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