A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Object Relational Mapping
how to Join Multiple tables
Joined: Sep 12, 2006
Oct 18, 2006 07:26:00
Hi i need to join multiple tables, any one got any idea, how to do this in hibernate.
i have 5 diffrent tables, i need to get all the data from the 5 tables based on Primary key. (PK) is common in all tables.
Thanks for your time
Joined: Sep 06, 2006
Oct 18, 2006 08:15:00
Hi Vamsi, I hope it helps...
if join is necessary:
from Tabla1 T1 join Tabla2 T2 on T1.ID = T2.ID join ...
"La verdadera sabidur�a viene del temor de Dios"
I agree. Here's the link:
subject: how to Join Multiple tables
How to generate queries with random joins
Is Nested Join possible, mapping a POJO to multiple tables.
problem with accessing resultset from multiple tables
SEVERE: Duplicate entry '1' for key 'PRIMARY'
Query on BMP
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014