mapping with multiple join

josephe · **Joined:** Fri Jul 16, 2004 9:43 am **Posts:** 3

hi everybody

I have 28 tables "for my exemple I'll take juste 4"

table1( table1_id
table2_id
table10_id
table11_id
.......................
proprety_A
property_B
..................)

table2(table2_id
table3_id
C
D)

table3(table3_id
propetyE
.............)

table4(table4_id
table3_id
propertyG
................)

I have table per class but I need to import several data (property_A, B, C,D,E,G) so i creat a new class

myclass{
A
B
C
D
E
G
..........
}

so how should I map this class

Thanx

emmanuel · **Posted:** Fri Jul 16, 2004 10:00 am

What you want is not very clear. You'll only have myclass and no other for the 4 tables?

josephe · **Joined:** Fri Jul 16, 2004 9:43 am **Posts:** 3

I have also myclass1 for the first table myclass2 for the 2nd and so on what i want it's to map myclass with table1 ...... table4 and send just one query to obtein a list of data i need

emmanuel · **Posted:** Fri Jul 16, 2004 10:16 am

Do a view in your DB and map this view to MyClass

josephe · **Joined:** Fri Jul 16, 2004 9:43 am **Posts:** 3

it works

thanx