select a.TABLE_ID ,a.F_P_ID1,b.name as name1 from salesorder a,attribute b where a.F_P_ID1=b.F_P_ID
union all
select a.F_P_ID2 ,b.name as name2 from salesorder a,attribute b where a.a.F_P_ID2=b.F_P_ID
union all
select a.F_P_ID3 ,b.name as name3 from salesorder a,attribute b where a.a.F_P_ID3=b.F_P_ID
union all
select a.F_P_ID4 ,b.name as name4 from salesorder a,attribute b where a.a.F_P_ID4=b.F_P_ID
union all
select a.F_P_ID2 ,b.name as name2 from salesorder a,attribute b where a.a.F_P_ID2=b.F_P_ID
union all
select a.F_P_ID3 ,b.name as name3 from salesorder a,attribute b where a.a.F_P_ID3=b.F_P_ID
union all
select a.F_P_ID4 ,b.name as name4 from salesorder a,attribute b where a.a.F_P_ID4=b.F_P_ID
TEMP3.FPID3,TEMP3.NAME3,TEMP4.FPID4,TEMP4.NAME4
FROM SALESORDER SALE,
(SELECT A.TABLE_ID TID,A.F_P_ID1 FPID1,B.NAME NAME1 FROM SALESORDER A,ATTRIBUTE B WHERE A.F_P_ID1=B.F_P_ID) TEMP1,
(SELECT A.TABLE_ID TID,A.F_P_ID2 FPID2,B.NAME NAME2 FROM SALESORDER A,ATTRIBUTE B WHERE A.F_P_ID2=B.F_P_ID) TEMP2,
(SELECT A.TABLE_ID TID,A.F_P_ID3 FPID3,B.NAME NAME3 FROM SALESORDER A,ATTRIBUTE B WHERE A.F_P_ID3=B.F_P_ID) TEMP3,
(SELECT A.TABLE_ID TID,A.F_P_ID4 FPID4,B.NAME NAME4 FROM SALESORDER A,ATTRIBUTE B WHERE A.F_P_ID4=B.F_P_ID) TEMP4
WHERE SALE.TABLE_ID = TEMP1.TDI AND SALE.TABLE_ID = TEMP2.TDI AND SALE.TABLE_ID = TEMP3.TDI AND SALE.TABLE_ID = TEMP4.TDI