Collapsing overlapping rows from multiple joined tables into as few rows as possible

[aj786]

Table_Design:\[code\]ID"Alpha""Beta"\[/code\]Table_Size:\[code\]Design_ID Size"Alpha" S"Alpha" M"Alpha" L"Beta" S"Beta" L\[/code\]Table_Color:\[code\]Design_Id Color"Alpha" "Black""Alpha" "Blue""Alpha" "Red""Alpha" "Green""Beta" "Orange"select D.ID, S.Size, C.Color fromTable_Design DLeft Outer JoinTable_Size SON D.ID = S.Design_IdLeft Outer JoinTable_Color CON D.ID = C.Design_IdwhereD.ID = 'Alpha'\[/code\]Yields:\[code\]D.ID S.Size C.ColorAlpha S BlackAlpha S BlueAlpha S RedAlpha S GreenAlpha M BlackAlpha M BlueAlpha M RedAlpha M GreenAlpha L BlackAlpha L BlueAlpha L RedAlpha L Green\[/code\]Is there anyway to write a query to return this instead:\[code\]D.ID S.Size C.ColorAlpha S BlackAlpha M BlueAlpha L RedAlpha Green\[/code\]