CREATE TABLE tbl01
(
    [id] int NOT NULL PRIMARY KEY,
    [name] nvarchar(50) NOT NULL
)

CREATE TABLE tbl02
(
    [subId] int NOT NULL PRIMARY KEY ,
    [id] int NOT NULL REFERENCES tbl01(id),
    [val] nvarchar(50) NULL,
    [code] int NULL
)

SELECT
   tbl01.id, tbl01.name, tbl02.val, tbl02.code
FROM
   tbl01
INNER JOIN
   tbl02 ON tbl01.id = tbl02.id

-------------------------------
id  | name  | val       | code
-------------------------------
1   | one   | FirstVal  | 1
1   | one   | SecondVal | 2
2   | two   | YourVal   | 1
2   | two   | OurVal    | 2
3   | three | NotVal    | 1
3   | three | ThisVal   | 2
-------------------------------

if(code = 1) then val as val-1
else if (code = 2) then val as val-2

-------------------------------
id  | name  | val-1     | val-2
-------------------------------
1   | one   | FirstVal  | SecondVal
2   | two   | YourVal   | OurVal
3   | three | NotVal    | ThisVal
-------------------------------

SELECT  tbl01.id, tbl01.name, MAX(tbl02.val), MIN(tbl02.val), tbl02.code
FROM    tbl01
INNER JOIN tbl02 ON tbl01.id = tbl02.id
GROUP BY tbl02.id