我的意思是Cognos SQL select PRODUCT.PRODUCT_NUMBER as 商品编码, PRODUCT.PRODUCT_TYPE_CODE as 小类编码, PRODUCT_TYPE.PRODUCT_TYP...
显示全部我的意思是
Cognos SQL
select
PRODUCT.PRODUCT_NUMBER as 商品编码,
PRODUCT.PRODUCT_TYPE_CODE as 小类编码,
PRODUCT_TYPE.PRODUCT_TYPE_EN as 小类名称,
PRODUCT_LINE.PRODUCT_LINE_CODE as 大类编码,
PRODUCT_LINE.PRODUCT_LINE_EN as 大类名称,
PRODUCT.PRODUCT_COST as 成本,
PRODUCT.MARGIN as 利润,
PRODUCT.MARGIN11 as 利润1,
ORDER_DETAIL.ORDER_NUMBER as 订单编号,
ORDER_DETAIL.SHIPO_DATE as 订单日期,
ORDER_DETAIL.UNIT_SALE_PRICE as 销售价格,
TIMESTAMP '2014-03-22 10:13:00.000' as 订单执行日期
from
local_mid..PSDSS_MID.PRODUCT PRODUCT,
psdss_mid..PSDSS_MID.PRODUCT_TYPE PRODUCT_TYPE,
psdss_mid..PSDSS_MID.PRODUCT_LINE PRODUCT_LINE,
psdss_mid..PSDSS_MID.ORDER_DETAIL ORDER_DETAIL
where
(PRODUCT.PRODUCT_TYPE_CODE = PRODUCT_TYPE.PRODUCT_TYPE_CODE) and
(PRODUCT_TYPE.PRODUCT_LINE_CODE = PRODUCT_LINE.PRODUCT_LINE_CODE) and
(ORDER_DETAIL.PRODUCT_NUMBER = PRODUCT.PRODUCT_NUMBER)
Native SQL
select "ORDER_DETAIL"."ORDER_NUMBER", "ORDER_DETAIL"."SHIPO_DATE", "ORDER_DETAIL"."UNIT_SALE_PRICE", "ORDER_DETAIL"."PRODUCT_NUMBER" from "PSDSS_MID"."ORDER_DETAIL" "ORDER_DETAIL" select "PRODUCT"."PRODUCT_NUMBER", "PRODUCT"."PRODUCT_TYPE_CODE", "PRODUCT"."PRODUCT_COST", "PRODUCT"."MARGIN", "PRODUCT"."MARGIN11" from "PSDSS_MID"."PRODUCT" "PRODUCT" select "PRODUCT_TYPE"."PRODUCT_TYPE_EN", "PRODUCT_LINE"."PRODUCT_LINE_CODE", "PRODUCT_LINE"."PRODUCT_LINE_EN", "PRODUCT_TYPE"."PRODUCT_TYPE_CODE" from "PSDSS_MID"."PRODUCT_TYPE" "PRODUCT_TYPE", "PSDSS_MID"."PRODUCT_LINE" "PRODUCT_LINE" where "PRODUCT_TYPE"."PRODUCT_LINE_CODE"="PRODUCT_LINE"."PRODUCT_LINE_CODE"
能帮我看下吗,这个是修改了关联关系后生成的sql有没有问题
收起