select distinct SCUSER NT_ID, ABALPH, ULUGRP
from sys7334.F0092 a, sys7334.f98owsec b, proddta.F0101 c
where a.ULUSER = b.SCUSER
and a.ULUSER = c.ABALKY
and b.SCEUSER = '01'
and c.ABAT1 = 'E'
order by ULUGRP;
from sys7334.F0092 a, sys7334.f98owsec b, proddta.F0101 c
where a.ULUSER = b.SCUSER
and a.ULUSER = c.ABALKY
and b.SCEUSER = '01'
and c.ABAT1 = 'E'
order by ULUGRP;
No comments:
Post a Comment