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 |
|
mmqsql
Starting Member
2 Posts |
 Posted - 2008-10-11 : 20:30:46
|
| I have like 6 tables that I am joining together. Tables A and B seem to have a one-to-many relationship. If I join tables A and B via another table C for example, is there any way the relationship between A and B is going to be changed to a one-to-one relationship?Does the way in which we join tables (I mean joining via another table or joining with another table) change the relationship between two tables? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-12 : 02:35:44
|
| the original relationship will never change based on your join. however the resultset you get will vary based on how you're joining the tables (the columns in volved in the join). The columns used in join based on if its column participating in many relationship or not causes the output to vary. |
 |
|
|
|
|
|
relationships