Simple SQL Query- Exchanging IntegerID With Name From Other Table.

 Hi Guys,

I have the following query:

 SELECT DecisionSessionID, RuleID, Operator1, Criteria1, AttributeForCriteria1, Operator2, Criteria2, AttributeForCriteria2, Operator3, Criteria3,
AttributeForCriteria3, Result
FROM myTable
WHERE (SessionID = @SessionID) 


Now I want that instead of the complicated Criteria1, Crieria 2 and Criteria 3 values the users sees the names which
are defined in myCriteria. I though the query might then look like this


 SELECT
DecisionSessionID,
RuleID,
Operator1,
Criteria1 (SELECT CriteriaName FROM myCriteria WHERE Criteria1 = CriteriaID),
AttributeForCriteria1,
Operator2,
Criteria2 (SELECT CriteriaName FROM myCriteria WHERE Criteria2 = CriteriaID).
AttributeForCriteria2,
Operator3,
Criteria3 (SELECT CriteriaName FROM myCriteria WHERE Criteria3 = CriteriaID),
AttributeForCriteria3,
Result
FROM dbo.aspnet_FuzzyRules
WHERE (DecisionSessionID = @DecisionSessionID) 


I am not very familiar with the sql syntax and as you can imagine the above psyeudo version is not really working.
Do you know how the correct syntax for such a nested query would look like?

many thanks,

polynaux