Table A
|   id  |   name    |
---------------------
|   1   |   John    |
|   2   |   Jim     |
|   3   |   Joe     |


Table AC
|   id  |   id_a    |   id_c    |
---------------------------------
|   1   |   1       |   1       |
|   2   |   1       |   4       |
|   3   |   2       |   2       |
|   4   |   3       |   3       |
|   5   |   3       |   1       |


Table C
|   id  |   name    |
---------------------
|   1   |   Pie     |
|   2   |   Cake    |
|   3   |   Burger  |
|   4   |   Ice     |