|
From: Carfield Y. <car...@ca...> - 2005-09-20 10:11:07
|
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? |