Untitled
unknown
plain_text
a year ago
553 B
4
Indexable
select createdbyid.name as created_by, saib.createdon + interval '3 hour' as created_on, modifiedbyid.name as modified_by, saib.modifiedon + interval '3 hour' as modified_on, saib.smaccountid as account_identificator, saib.smbrandid as brand_identificator, saib.smaccountbillinginfoid as account_billing_info_identificator from vw_ods_bpm_soft.vw_smaccountinbrand saib left join vw_ods_bpm_soft.vw_contact createdbyid on createdbyid.id = saib.createdbyid left join vw_ods_bpm_soft.vw_contact modifiedbyid on modifiedbyid.id = saib.modifiedbyid;
Editor is loading...
Leave a Comment