#DateForumTypeThreadPost
105 Nov 2009 @ 03:59 PSTUDAReplyHow to add in Select Statement inside Case?SELECT T1.Manager_ID,T1.Manager_Name,T1.COMPANY,Case when T1.Manager_id = 'CARE' and T1.Manger_Name = T2.Manager_Name then T2.Manager_ID ELSE T1.Manger_IdEND as Manager_ID2FromTable1 ...