Forum Discussion
McClendon111
Mar 24, 2024Copper Contributor
SQL Relationships
Is this right (valid)?
The Garment Table has a Many to Many, Recursive relationship.
1 Dress can be matched with many Coats.
1 Coat can be matched with many Dresses.
- olafhelperBronze Contributor
Is this right (valid)?McClendon111 , we don't know your business rules, so know one can say, if it's right or wrong.
- McClendon111Copper Contributor
Thanks for your reply. I'm only asking if that kind of relationship is possible, valid, techinicqlly speaking. I believe it it but it's been 20 years since I've worked with SQL databases logic
- olafhelperBronze ContributorOf course is a many-to-many relation possible and can be valid.