Hi David,

Here is my exact one

Here is the one

USER_PRFL

User_Id User_FullName Email User_Group

BSP_LOB_Grp_Lookup

BSP_LOB_GRP BSP_LOB_CD BSP_LOB_GRP_TYPE_CD

IMPACTED_LOB

Event_ID BSP_LOB_CD

Scenario1:

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

Now I have a value called CCSG Group in BSP_LOB_GRP column in BSP_LOB_Grp_Lookup table. So now this CCSG Group has its respective BSP_LOB_CD in same table. Now I need to compare BSP LOB_CD column of BSP_LOB_Grp_Lookup and IMPACTED_LOB and display the result for that particular group.

On top of this the following values (Life, MLCT, GenAm, NEF, Annuity, Auto and Home, Annuity and Investments) present in BSP_LOB_GRP should belong to CCSG Group of the sane column.