Here is the one

User_Profile

User_Id User_FullName Email User_Group

Group_Lookup

LOB_GRP LOB_CD LOB_TYPE_CD

Impacted_LOB

Event_ID LOB_CD

First user log-ins which is queried in User_Profile table. Then I try to relate User_Group and LOB_GRP.

Then I have a group called CCSG Group in LOB_GRP column in Group_Lookup table. So now this CCSG Group has its respective LOB_CD in same table. Now I need to compare LOB_CD column of Group_Lookup and Impacted_LOB and display the result for that particular group.