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.
McClendon111
Mar 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!