combining fields

[ben]

I'm pretty much retarded when it comes to stuff like
this...but i'm guessing something other than "union" is
supposed to go where you have union. I have tried the
method you suggested, but i can't get it to work.

Here is the SQL that i started with:

SELECT [Shaft Description Data - BEN].[Shaft Mfg], [Shaft
Description Data - BEN].[Shaft Description], [Shaft
Description Data - BEN].[Flex], [Profile Data - Torsion -
BEN].[Deg @ 12 5/8"], [Profile Data - Torsion - BEN].[Deg
@ 17 5/8"], [Profile Data - Torsion - BEN].[Deg @ 22
5/8"], [Profile Data - Torsion - BEN].[Deg @ 27 5/8"],
[Profile Data - Torsion - BEN].[Deg @ 32 5/8"], [Profile
Data - Torsion - BEN].[Deg @ 37 5/8"]
FROM [Profile Data - Torsion - BEN] INNER JOIN [Shaft
Description Data - BEN] ON [Profile Data - Torsion -
BEN].Counter = [Shaft Description Data - BEN].Counter;


The 3 fields i want to become 1 field are the first 3 in
the SQL ([Shaft Mfg], [Shaft Description], and [Flex])

Thanks for any help
Ben