Combining Duplicate Product Numbers.

Hey guys! I am running into another problem, it seems the more i know the more I find out I need to learn!!

So here is the situation. I have 2 tables. One table is comprised of 2 columns

Product # | Variation #

Table # 2 is made up of 2 columns

Variation # | Variation Name

A product # can have multiple variations and therefore return multiple rows. If i use this very simple code.



SELECT dbo.TABLE1.Product_Number, dbo.TABLE2.VariationName
FROM dbo.TABLE1
INNER JOIN dbo.TABLE 2
ON dbo.TABLE1.VariationNumber = dbo.TABLE2.VariationNumber

I am getting

Product# | VariationName

111 | Blue
111 | Big
111 | Tall

How do I get it to pull up as

Prodcut # | VariationName

111 | BLUE BIG TALL


You guys have always been so helpful. Any advice would be super!