SELECT
INVOICE."BUYERADDRESS1", INVOICE."BUYERADDRESS2", INVOICE."BUYERADDRESS3", INVOICE."SHIPPEDPER", INVOICE."LCNO", INVOICE."FROMPLACE",
INVOICE_D."NO", INVOICE_D."DETAIL"
FROM
"SILK_RSL"."INVOICE" INVOICE,"SILK_RSL"."INVOICE_D" INVOICE_D
where
INVOICE."NO" = INVOICE_D."NO"(+);
INVOICE."BUYERADDRESS1", INVOICE."BUYERADDRESS2", INVOICE."BUYERADDRESS3", INVOICE."SHIPPEDPER", INVOICE."LCNO", INVOICE."FROMPLACE",
INVOICE_D."NO", INVOICE_D."DETAIL"
FROM
"SILK_RSL"."INVOICE" INVOICE,"SILK_RSL"."INVOICE_D" INVOICE_D
where
INVOICE."NO" = INVOICE_D."NO"(+);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货