SQL To Get The Email Address From The Address Book Who’s Who For Each User Profile

Below is the SQL used to get the emails address from the Address Book Whos Who (F01151) for each user profile (F0092):

 SELECT A.ULUSER,A.ULAN8, B.EAEMAL  FROM JDE910.SY910.F0092 A, JDE_PRODUCTION.PRODDTA.F01151 B  WHERE ULUGRP'*GROUP' AND B.EAAN8 IN (SELECT ABAN8 FROM TESTDTA.F0101 WHERE ABAT1='E') AND A.ULAN8=B.EAAN8 ORDER BY ULAN8 

Leave a Reply