select * from dsUser U inner join dsUserRole ur on ur.UserID=U.UserID where U.Name like '%ilhan%' and U.FamilyName like '%AKPINAR%' --and U.UserID=2165214 order by ExpirationDate desc select * from dsUser U inner join dsUserRole ur on ur.UserID=U.UserID where U.Name like '%CUNEYD%' and U.FamilyName like '%TANRIVERDI%' and U.UserID=1647938 order by ExpirationDate desc --35 ROLE ID master update dsUserRole set RoleID=76 where UserID=1647938 and RoleID=13 select * from dsUserRole where UserID=1647938 and RoleID=76
