Unnecessary commas generated in sub-select left outer joins ----------------------------------------------------------- Key: HHH-826 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-826 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.0.5, 3.1 beta 1 Environment: Windows 2k, Oracle9 Reporter: M Manning Assignee: Steve Ebersole Priority: Minor Attachments: subselectInJoin.zip The HQL statement : select w.id FROM Work w WHERE w.id in (Select w2.id from Work w2 left join w2.workDocTypes wdt2 WHERE wdt2.docDescription = 'Test type') gets parsed to the SQL: select work0_.BIB_ID as col_0_0_ from WORK work0_ where work0_.BIB_ID in (select work1_.BIB_ID from WORK work1_, left outer join WORK_DOC_TYPE workdoctyp2_ on work1_.BIB_ID=workdoctyp2_.WORK_ID_FK left outer join DOC_TYPE doctype3_ on workdoctyp2_.DOC_TYPE_ID_FK=doctype3_.ID where doctype3_.DOC_DESCRIPTION='Test type') With a comma after the work1_ in the subselect, causing the query to fail. This seems to be similar to/related to issue HHH-554 & HHH-706, however the comma appears after the table, not between the join clauses