Extract order data from CRMD_PRICING_I and PRCD_COND tables

[vbisadi]

Hello,

I'm trying to extract some order information from CRMD_PRICING_I and PRCD_COND tables. I'm using the following query:

SELECT * FROM

CRMD_ORDERADM_H AS ORDH

INNER JOIN CRMD_ORDERADM_I AS ORDI ON ORDI.header = ORDH.GUID

LEFT JOIN CRMD_PRICING_I AS PRICING ON PRICING.GUID = ORDI.GUID

LEFT JOIN CRMD_LINK AS LINK ON LINK.GUID_HI = ORDI.GUID

LEFT JOIN PRCD_HEAD ON LINK.GUID_SET = PRCD_HEAD.KNUMV

LEFT JOIN PRCD_COND ON PRCD_HEAD.KNUMV = PRCD_COND.KNUMV

But this query returns all null records from PRCD_COND table. I'm not familiar with the details of CRM model so I'm not sure if I'm using correct keys. I really appreciate if someone can help me to check if I'm using the correct keys in this query.

Regards,

Vahid