1,105,402 Community Members

Many-to-Many Relations, How to?

Member Avatar
Vincentas
Junior Poster in Training
62 posts since Nov 2012
Reputation Points: 6 [?]
Q&As Helped to Solve: 5 [?]
Skill Endorsements: 0 [?]
 
0
 

Hello,

Let's say I have 2 tables:

  • projects
  • users

and I need to relate them so that a user can work on one or more projects and a project can be worked by one or more users.

How to implement this without having a third table ?? It this possible??

Member Avatar
pritaeas
mod_pritaeas
11,295 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,832 [?]
Skill Endorsements: 155 [?]
Moderator
Featured
Sponsor
 
0
 

How to implement this without having a third table ?? It this possible??

Not recommended. Third table is your best option. What would be the reason for not using one?

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article