CREATE table transfer ("id" int(8),"to" int(8), "from" int(8), amount int(8), "type" varchar(1));
insert into transfer values (1,2,3,100,'C');
insert into transfer values (2,3,2,200,'C');
 
create table data ("id" int(8), "name" varchar(32));
insert into data values (2,"PQR");
insert into data values (3,"XYZ");
 
select 
case when "from"=2 then "to" when "to"=2 then "from" end "from/to"
,amount,"type" from transfer;
 
select 
case when "from"=2 then d.name when "to"=2 then data."name" end "from/to"
,amount,"type" from transfer join data on transfer."from" = data."id"
JOIN data d ON transfer."to"=d."id";

Q1JFQVRFIHRhYmxlIHRyYW5zZmVyICgiaWQiIGludCg4KSwidG8iIGludCg4KSwgImZyb20iIGludCg4KSwgYW1vdW50IGludCg4KSwgInR5cGUiIHZhcmNoYXIoMSkpOwppbnNlcnQgaW50byB0cmFuc2ZlciB2YWx1ZXMgKDEsMiwzLDEwMCwnQycpOwppbnNlcnQgaW50byB0cmFuc2ZlciB2YWx1ZXMgKDIsMywyLDIwMCwnQycpOwoKY3JlYXRlIHRhYmxlIGRhdGEgKCJpZCIgaW50KDgpLCAibmFtZSIgdmFyY2hhcigzMikpOwppbnNlcnQgaW50byBkYXRhIHZhbHVlcyAoMiwiUFFSIik7Cmluc2VydCBpbnRvIGRhdGEgdmFsdWVzICgzLCJYWVoiKTsKCnNlbGVjdCAKY2FzZSB3aGVuICJmcm9tIj0yIHRoZW4gInRvIiB3aGVuICJ0byI9MiB0aGVuICJmcm9tIiBlbmQgImZyb20vdG8iCixhbW91bnQsInR5cGUiIGZyb20gdHJhbnNmZXI7CgpzZWxlY3QgCmNhc2Ugd2hlbiAiZnJvbSI9MiB0aGVuIGQubmFtZSB3aGVuICJ0byI9MiB0aGVuIGRhdGEuIm5hbWUiIGVuZCAiZnJvbS90byIKLGFtb3VudCwidHlwZSIgZnJvbSB0cmFuc2ZlciBqb2luIGRhdGEgb24gdHJhbnNmZXIuImZyb20iID0gZGF0YS4iaWQiCkpPSU4gZGF0YSBkIE9OIHRyYW5zZmVyLiJ0byI9ZC4iaWQiOw==