Karim_Azzouzi_8427

Looking for all activites of a specific user SQL statement

Discussion created by Karim_Azzouzi_8427 on Jan 11, 2017
Here is the sql query to search for all active objects by user :

select EH_Name, EH_AH_IDnr, EH_Usr_Idnr, USR_FirstName, USR_LastName, USR_EMail1, OH_Name, EH_RDate
from EH left join USR
on EH_Usr_Idnr = USR_OH_Idnr
left join OH
on USR_OH_Idnr = OH_Idnr
where 1=1
and OH_Name='USR/DEP'

Outcomes