This is my query. I have attached the output I am getting. How can I modify the query to get the userID and name only once.
SELECT C.ID, C.StudentID,c.ClassID, c.InstructorID ,c.TimeID ,(rtrim(U.UserFirstName)) + '' +
ltrim(rtrim(U.UserLastName)) as UserName,
ltrim(rtrim(U.AttendenceDay)) as AttendenceDay FROM CLASSSETUP as C
LEFT OUTER JOIN USERDETAILS As U on C.StudentID=U.UserID
Where C.ClassID =15 order by UserName Query.txt
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.