3 Replies Latest reply: May 17, 2016 4:09 AM by Gysbert Wassenaar RSS

    many to many relationship

    tom herman

      hello.

      i have those 2 tables with many to many relationship

      the problem is that one donation can have many equipment and the same equipment can be in many donations(there are many of it)

      i need to fins all equipment that one donation has

       

      equipment_id

      equipment_name
      123A
      234B
      345C
      456D
      567E
      678F

       

      equipment_iddonation_id
      123AABBCCDD
      234AABBCCDD
      345AABBCCDD
      456AABBCCDD

       

       

      i need to have one table with all this information