SELECT A.PRODUCT_NAME TY,B.PRODUCT_NAME PD,B.PRICE FROM TB A,TB B WHERE A.PARENT_PRODUCT_CODE IS NULL AND B.PARENT_PRODUCT_CODE IS NOT NULL AND B.PARENT_PRODUCT_CODE = A.PRODUCT_CODE
这样查出来作为数据集再做报表就可以啦
SELECT A.PRODUCT_CODE,A.PRODUCT_NAME,B.PRODUCT_CODE,B.PRODUCT_NAME FROM CUX.CUX_TEST A,CUX.CUX_TEST B WHERE A.PARENT_PRODUCT_CODE IS NULL AND B.PARENT_PRODUCT_CODE IS NOT NULL AND B.PARENT_PRODUCT_CODE = A.PRODUCT_CODE