Related issues with Table associations

Table-related issues
There are three tables, which are album table, product table, Picture table, respectively.
Requirements: Albums can be stored in both products and pictures.
How would you like to express the relationship between the three people?

I analyzed that albums and products are many-to-many relationships, and albums and pictures are many-to-many relationships.
Do you want to design two intermediate tables?

Share to:

------Solution--------------------
then separate it.
Feature ID Product ID
Feature ID Image ID

Since it's two entities, why do you have to pull it together? Do you want to design two intermediate tables?
------Solution--------------------
SELECT * from A LEFT join A_b on A.id=a_b.aid left join A_c on A.id=a_c.aid
------Solution--------------------
That's for sure!
But you just need to INNER JOIN.

