SQL To Get The Email Address From The Address Book Who’s Who For Each User Profile
Read Time:18 Sec
Below is the SQL used to get the emails address from the Address Book Who’s 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
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Average Rating