[Hsqldb-developers] Question about ANSI inner table

[Carfield Y. <car...@ca...>]

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 =3D
currcourses.currid) INNER JOIN transcript transcript_module ON
transcript_module.eventid =3D currcourses.eventid) INNER JOIN cschedule
cschedule ON transcript_module.eventid =3D cschedule.eventid) INNER JOIN
learningObject learningObject ON learningObject.learningid =3D
cschedule.courseid) INNER JOIN transcript transcript_program ON
transcript_program.sessionid =3D currcourses.sessionid) INNER JOIN catalog
catalog ON currcourses.courseid =3D catalog.learningid) INNER JOIN
user_orgs user_orgs ON user_orgs.userid =3D transcript_module.userid)
INNER JOIN users users ON users.userid =3D 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?