Untitled

 avatar
unknown
sql
a year ago
768 B
1
Indexable
select
aa.accountid as account_identificator,
aa.address as address,
address_type.name as address_type,
city.name as city,
createdby.name as created_by,
aa.createdon + interval '3 hour' as created_on,
modifiedby.name as modified_by,
aa.modifiedon + interval '3 hour' as modified_on,
aa."Primary" as "primary",
aa.smhouse as house,
aa.smstreet as street,
aa.zip as zip,
aa.id as identificator
from vw_ods_bpm_soft.vw_accountaddress aa
left join vw_ods_bpm_soft.vw_addresstype address_type
    on address_type.id = aa.addresstypeid
left join vw_ods_bpm_soft.vw_city city
    on city.id = aa.cityid
left join vw_ods_bpm_soft.vw_contact createdby
    on createdby.id = aa.createdbyid
left join vw_ods_bpm_soft.vw_contact modifiedby
    on modifiedby.id = aa.modifiedbyid;
Leave a Comment