Hello.
We have below 2 queries , could some one let me know which would be best way to
join these 2 queries ?
1.
SELECT
A.LECY_IEM_NBR,
C.STRE_NBR,
COALESCE((E.PRICE_DEST_ID),0)
FROM P12MITM.IEM_LEGACY_XREF A,
P12AMITM.IEM B,
P12SPRICE.PRICING_ACT E
LEFT OUTER JOIN P12SPRICE.PRTCE_DEST C
ON E.PRICE_DEST_ID = C.PRICE_DEST_ID
AND E.PRICE_DEST_TYPE = 7
WHERE A.ITEM_NBR = B.ITEM_NBR
AND B.MDS_FAM_ID = E.ITEM_SOURCE_ID
2.
SELECT CLC_VALUE
INTO :CALC-VALUE
FROM P12SPRICE.PRICING_ACT A
WHERE A.ITEM_SOURCE_ID = :ITEM-DATA.MDS-FAM-ID
AND A.PRICE_DEST_ID = 7
AND PRICE_TYPE_CODE = 2
AND COST_TYPE_CODE = 0
AND PRICING_REASON_CD = 10
AND PRICE_ACTN_STAT_CD = 210
AND EFFECTIVE_DATE <= CURRENT DATE
AND EXPIRATION_DATE > CURRENT DATE
Thanks.
Rajeev V
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
