I think you can try to use Pivot/Unpivot to make that. I have try with 3 Fields, like this :

SELECT *
FROM (
    SELECT Id, Field, Code.CodeValue
    FROM 
        (SELECT Id, Field1, Field2, Field3 FROM InvoiceDevice) AS sourc
        UNPIVOT (CodeId FOR Field IN (Field1, Field2, Field3)) AS unpvt
        INNER JOIN Code ON Code.Code = unpvt.CodeId
) AS unpivoted
PIVOT
(
    MIN(CodeValue)
    FOR Field IN (Field1, Field2, Field3)
) AS pvt;

But no idea about performance...

Might be that this is a simple question of JOIN ?

Not knowing your tables structure my magic crystal ball tells me you might be looking for something like this:

SELECT t.*
      ,c.* 
FROM YourTable t
INNER JOIN InvoiceDevice AS id ON t.code=id.DeviceType
INNER JOIN Code AS c ON c.CodeValue=id.CodeValue

The actual table and column names will need adaptions...

If the code entries within your tables are not unique for a given value, there might be additional columns you need to use as filters.

UPDATE

Reading your question once again it sounds like there are just two tables involved. In this case something like this should help:

SELECT id.*
      ,c.* 
FROM InvoiceDevice AS id 
INNER JOIN Code AS c ON c.CodeValue=id.CodeValue