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
解决方案 »
- ora-12514:TNS:listener does not currently know of service requested in connect
- 我安装了一个mysql,打不开客户端
- oracle 的全文索引与普通索引只能被使用其中一个吗
- .net调用oracle带返回值存储过程的问题
- 在Oracle中,能说说建立 Sequences的作用吗?
- 第一次运行SQLPLUS时,提示ORACLE initialization or shutdown in progress 是什么意思,应该怎么办??在线等
- 存储过程编译错误
- 帮我看一下!
- 急急急!!!!怎样在Orcale过程中执行一句SQL(SQL放在一个Varchar变量中)
- 一个关于ORACLE9I的问题,请各位高手进来,急急急急急急!!!!!!!!!!!!
- 关于PHP来编译函数/过程的问题...
- oracle 触发器??
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