Q:

Merging two or more columns from different SQL queries

I'm having a hard time figuring out how to merge together two columns with sql (I'm new at it).  It should be really simple but I simply can't find a way to do it.  I have two results from two different selects statements, and they both have the same number of rows, but different columns.  I just want to "attach" all the columns together.  
Example. 
This is the first table:

This is the second table:

The following query:
SELECT [t].*  FROM [TrainerClass] AS [t];

or simply
SELECT * FROM [TrainerClass];

will give the result shown here:

Now, the second query, which is:
SELECT [d].[Description] AS [Name] FROM [DescriptionTranslation] AS [d], [TrainerClass] AS [t] WHERE [d].[TableName] = 'TrainerClass' AND [d].[FieldName] = 'Name' AND [d].[Code] = [t].[Code] AND [d].[Language] = 'en-EN';

will result in this table:

Pretty straight forward.  Now, what I simply want to get is this:

Why is it so hard to me?  What would you do to achieve that?  Thanks in advance! 

A:

SELECT [t].*, 
       [d].[Description] AS [Name],
       [d2].[Description] AS [Description]
FROM   [TrainerClass] AS [t] join [DescriptionTranslation] AS [d] on [t].[Code] = [d].[Code]
       join [DescriptionTranslation] AS [d2] on [t].[Code] = [d2].[Code]
WHERE  [d].[TableName] = 'TrainerClass' AND 
       [d].[FieldName] = 'Name' AND 
       [d].[Language] = 'en-EN' AND
       [d2].[FieldName] = 'Description'

