Hi, I find the followign sql is not supported though it is SQL92 compliant. The parenthesis around table-expression is not supported. In my example the table-expression is a join-table-expression.
SELECT THIS.STRINGWIDGET_ID,THIS.NORMAL_STRING,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD,THIS.FIXED_LENGTH_STRING FROM (STRINGWIDGET INNER JOIN WIDGET ON STRINGWIDGET.STRINGWIDGET_ID = WIDGET.WIDGET_ID) THIS WHERE THIS.INT_FIELD < 0 ORDER BY THIS.NORMAL_STRING DESC Regards, Rice __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus ------------------------------------------------------- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
