Can you run SQL2005??

If you can you can use a couple of CTE's.

With Table1(UserID,Name) as

(

your select statement to grab data

),

Table2(UserID,Class)

(

again your select statement

)

Select Table1.UserID,Name,Class Into NewTab

From Table1,Table2

Where Table1.UserID=Table2.UserID

 

I wasn't...