Untitled
unknown
sql
a year ago
736 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 vw_ods_bpm_soft.vw_accountcommunication ac left join vw_ods_bpm_soft.vw_communicationtype communicationtype on communicationtype.id = ac.communicationtypeid left join vw_ods_bpm_soft.vw_contact created_by on created_by.id = ac.createdbyid left join vw_ods_bpm_soft.vw_contact modified_by on modified_by.id = ac.modifiedbyid;
Editor is loading...
Leave a Comment