A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Spring in Action
this week in the
Object Relational Mapping
why join keyword is needed
Joined: May 06, 2005
Dec 04, 2013 16:28:05
Being a entry level programmer, i want to know very basic thing. Why does hibernate queries need "Join" keyword. Is it just syntactical thing ?
In plain SQL, we can write something like Select from Employee e , Department d where
e.id == d.eid.
There is no Join keyword used here still its inner join. Is'nt ?
Joined: Mar 07, 2010
Dec 05, 2013 19:54:23
The join keyword is left off for example when there is no relationship between the entities as described in this post:
However implicit join syntax can be used where the associations are de-referenced using dot notations which results in an inner join in the resulting SQL statement.
Have a read of this blog, which I think did a pretty good job explaining things
How To Ask Questions
Read before you PM me
I agree. Here's the link:
subject: why join keyword is needed
r they keywords or literals?
main app won't stop when all threads are done running
org.hibernate.exception.GenericJDBCException: could not execute query
Urgent help needed Please.Urgent
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014