I am developing a java based program and also I have to normalise the DB. My problem at this phase of the development is to reorganise the database structure. I need a m:m relationship between records of the same table. Producers are linked to producers. I know how to do a many to many relationship with two different entities using a third "link" table. So the question is: can I use a second table with two fields (producer_id, producer_id) just to link records of the same table. What is the best solution for this relationship?