User-2057865890 posted
Hi sudip_inn,
A many-to-many relationship consists of three tables. Below is a schematic view of the many-to-many relationship.

In some cases, you may need multiple instances on both sides of the relationship. For example, each order can contain multiple items. And each item can also be in multiple orders.
For these relationships, we need to create an extra table:

The Items_Orders table has only one purpose, and that is to create a "Many to Many" relationship between the items and the orders.
Best Regards,
Chris