Forum Discussion

McClendon111's avatar
McClendon111
Copper Contributor
Mar 24, 2024

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.

 

 

    • McClendon111's avatar
      McClendon111
      Copper Contributor

      olafhelper 

       

      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

      • olafhelper's avatar
        olafhelper
        Bronze Contributor
        Of course is a many-to-many relation possible and can be valid.

Resources