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.
olafhelper
Mar 25, 2024Bronze Contributor
Is this right (valid)?
McClendon111 , we don't know your business rules, so know one can say, if it's right or wrong.
- McClendon111Mar 25, 2024Copper 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
- olafhelperMar 26, 2024Bronze ContributorOf course is a many-to-many relation possible and can be valid.
- McClendon111Mar 26, 2024Copper ContributorThanks!