[Hsqldb-developers] Question about ANSI inner table

[Carfield Yim]

I have the following SQL:


SELECT users.familyname, catalog.catalogid, learningObject.learningid,
cschedule.nregistered, transcript_module.enrollmentDat
e FROM ((((((( learningObject learningObject_program INNER JOIN
currcourses currcourses ON learningObject_program.learningid =
currcourses.currid) INNER JOIN transcript transcript_module ON
transcript_module.eventid = currcourses.eventid) INNER JOIN cschedule
cschedule ON transcript_module.eventid = cschedule.eventid) INNER JOIN
learningObject learningObject ON learningObject.learningid =
cschedule.courseid) INNER JOIN transcript transcript_program ON
transcript_program.sessionid = currcourses.sessionid) INNER JOIN catalog
catalog ON currcourses.courseid = catalog.learningid) INNER JOIN
user_orgs user_orgs ON user_orgs.userid = transcript_module.userid)
INNER JOIN users users ON users.userid = transcript_module.userid

which work ok for sql server and sybase, but hsql complaint syntax
error. To be honest I don't sure what the standard define, is that HSQL
not fully support standard inner join syntax, or sql server and sybase
support a non-standard inner join?