idCars   idSize
------   ------
1        3
1        2
2        1

##</code><code>##

Car          Size
----------   ----------
MiniCooper   sedan
MiniCooper   compact
Civic        subcompact

##</code><code>##

select Car, Size
from CarSize
join Cars
using(idCars)
join Size
using(idSize)