is it possible to write this sql using llblgens predicate expressions?
SELECT st.StudentID, da.DateOfAttendance, Attendance.AttendanceStatusType.Name
FROM Attendance.DailyAttendance AS da INNER JOIN
Attendance.AttendanceStatusType ON da.AttendanceStatusTypeID = Attendance.AttendanceStatusType.AttendanceStatusTypeID AND
da.AttendanceStatusTypeID = Attendance.AttendanceStatusType.AttendanceStatusTypeID RIGHT OUTER JOIN
(SELECT DISTINCT StudentID
FROM Core.Student) AS st ON da.StudentID = st.StudentID
ORDER BY st.StudentID
thank you
