Untitled
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