Hi Experts,
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.AttendenceDa
y)) 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
For example, user Eulisis_MiddleEu, do you want to see ID values 201, 160, 193, or none at all?
If you only want to see StudentID and UserName..
Open in new window