S找JOIN

SELECT prdint_id from S_SRV_REQ

SELECT ROW_ID from S_PROD_INT

 

情况二：

select a.ATTRIB_43,a.* from SIEBEL.S_SRV_REQ_X a
join SIEBEL.S_SRV_REQ b on A.PAR_ROW_ID=b.row_id