Unnecessary commas generated in select with left outer joins ------------------------------------------------------------ Key: HHH-1069 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1069 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.1 beta 1, 3.1 rc 1, 3.1 rc2 Environment: H3.1 beta 1, H3.1 rc1, H3.1 rc2 Database: Sybase 12.0.0.1 Reporter: Pierre Masse Assignee: Steve Ebersole Fix For: 3.1 rc3 Attachments: commas in the from clause.zip, NEW - commas in the from clause.zip Commas are inserted in the FROM clause, between each join. This is rejected as a syntax error by JDBC. If I send the Hibernate generated SQL, without the commas, I get my resultset (using a DB tool). Thanks for you help. I can't move forward if this is not resolved. I would greatly appreciate work around until this is solved. Let me know if you need more info.. Cheers.