Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlclarify
Yak Posting Veteran
56 Posts |
 Posted - 2008-10-10 : 21:09:11
|
| I know that if you have a many to many relationship between two tables you have an intermediate table between the two to resolve the many to many relationship. table A 1 to M intermediate table M to 1 table BBut does this intermediate table change the relationship between the two tables, that is, table A and table B to a 1 to 1 relationship? After adding this intermediate table what would the relationship between A and B be? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-11 : 01:00:05
|
| nope. still it will 1 to may. the intermediate table will have id from one table repeated for various id values of other table.i.e if tables are A & B intermidate table will contain one or more records per AID with different values for BID |
 |
|
|
|
|
|
many to many relationship?