Ratakan

Informations :

Smartlist Account Index TWO VS DEMO

Sintax Execute di DB TWO dan DEMO
create view ABC_Account_Index_TWO_DEMO
as
select coalesce (a.ACTNUMST,'') as ACTNUMST_TWO,
coalesce (a.ACTINDX,0) as ACTINDX_TWO,
coalesce (b.ACTINDX,0) as ACTINDX_DEMO 
from TWO..GL00105 a
inner join (select ACTNUMST,ACTINDX from DEMO..GL00105 ) b on a.ACTNUMST = b.ACTNUMST
union
select '',0 as ACTNUMST_DEMO,0 as ACTINDX_TWO
go
grant select on ABC_Account_Index_TWO_DEMO to DYNGRP

Hasilnya :








No comments