There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Anybody have idea to implement RIGHT JOIN in SharpHSQL engine.
SELECT S.StudentID, C.ClassID, C.ClassName, S.StudentName, SC.SchoolID, SC.SchoolName
FROM Student S
LEFT OUTER JOIN Class C
ON S.ClassID = C.ClassID
RIGHT OUTER JOIN School SC
ON SC.SchoolID = C.SchoolID