Hallo, in an existing application I got an exception and tracked it down to a generated query from the Java OR mapping solution Hibernate Actually I was suprised that the query does not work and created a simple use case to explain the problem (see and of this email). The postgre SQL exception is: ERROR: relation a does not exist It happens when a implicit join and a inner join is mixed. Do I have to except this as a fact or is there a logical explication for this behaviour. -- Best Regards / Viele Grüße Sebastian Hennebrueder ---- http://www.laliluna.de Tutorials for JSP, JavaServer Faces, Struts, Hibernate and EJB -- the following query has a inner join and an implicit join and does not work. select a.name as act_name, u.name as trainer from activity a, localgroup lg, sponsor spon inner join tuser u on a.fk_trainer=u.id where spon.name='Jimmy Rich' and spon.fk_localgroup=lg.id and lg.fk_activity=a.id -- implicit join passing two tables works select a.name as act_name from activity a, localgroup lg, sponsor spon where spon.name='Jimmy Rich' and spon.fk_localgroup=lg.id and lg.fk_activity=a.id -- Best Regards / Viele Grüße Sebastian Hennebrueder ---- http://www.laliluna.de Tutorials for JSP, JavaServer Faces, Struts, Hibernate and EJB Get support, education and consulting for these technologies - uncomplicated and cheap. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
