This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How do I map this?

 
Dushy Inguva
Ranch Hand
Posts: 264
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have 2 tables Table1 and Table2

Table1:
Primary Key:
A,B,C
Other Columns:
D,E

Table2:
Primary Key:
A,C,D,F
Other Columns:
X
Now, when I load Table1, i want to load rows of Table2 that match the following criteria:
Table1.A = Table2.A and Table1.D = Table2.D

Is this a many-to-many ? Is so, can I map it since i don't have a join table?
[ June 13, 2006: Message edited by: Dushy Inguva ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic