Untitled
unknown
sql
a year ago
705 B
6
Indexable
select ac."AccountId" as account_identificator, communicationtype."Name" as communication_type, created_by."Name" as created_by, ac."CreatedOn" + interval '3 hour' as created_on, modified_by."Name" as modified_by, ac."ModifiedOn" + interval '3 hour' as modified_on, ac."Number" as number, ac."Primary" as primary, ac."SmExternalCode" as external_code, ac."SmIsAccounting" as is_accounting, ac."Id" as identificator from "AccountCommunication" ac left join "CommunicationType" communicationtype on communicationtype."Id" = ac."CommunicationTypeId" left join "Contact" created_by on created_by."Id" = ac."CreatedById" left join "Contact" modified_by on modified_by."Id" = ac."ModifiedById"
Editor is loading...
Leave a Comment