Join 3 tables then loop data

This should be very easy, but not sure how to
approach this. Total table redesign is not out of the question since
i'm starting a new project... so if this isn't effecient or not the
right way to do it let me know.



I have 3 tables: Cars, CarsColors, and luColors



luColors

ID Color

1 Red

2 Blue

3 Green

4 Yellow



CarsColors

ID CarID luColorsID

1 1 3

2 1 4

3 2 1



Cars

ID Name

1 Accord

2 Civic

3 Camry



so as you can see, the Accord has Green and Yellow for colors. I need
to join all these tables somehow and loop through them using a
datareader and display just the car name and the colors next to it,
like this



"Accord comes in Green, Yellow."



If possible i would like t ...