FOR SELECT 0,
RLI_ITEMS.RLI_QTY_RLI,
GOODS.GDS_ID,
GOODS.GDS_CODE,
GOODS.GDS_NOTE,
BRAND.BRD_NAME,
EIZM.EIZ_NAME,
GOODS_CATEGORY1.GDC_NAME,
GOODS_CATEGORY2.GDC_NAME
FROM RLI_HEAD
INNER JOIN RLI_ITEMS ON (RLI_HEAD.RLH_ID = RLI_ITEMS.RLI_RLH_ID)
INNER JOIN GOODS ON (RLI_ITEMS.RLI_GDS_ID = GOODS.GDS_ID)
INNER JOIN EIZM ON (GOODS.GDS_EIZ_ID = EIZM.EIZ_ID)
INNER JOIN BRAND ON (GOODS.GDS_BRD_ID = BRAND.BRD_ID)
INNER JOIN GOODS_CATEGORY GOODS_CATEGORY1 ON (GOODS.GDS_GDC_ID1 = GOODS_CATEGORY1.GDC_ID)
INNER JOIN GOODS_CATEGORY GOODS_CATEGORY2 ON (GOODS.GDS_GDC_ID2 = GOODS_CATEGORY2.GDC_ID)
WHERE
(
(RLI_HEAD.RLH_DATE >= :I_DATE1)
AND
(RLI_HEAD.RLH_DATE <= :I_DATE2)
)
PLAN JOIN (RLI_HEAD INDEX (RLH_DATE),
RLI_ITEMS INDEX (RDB$FOREIGN29),
GOODS INDEX (RDB$PRIMARY5),
GOODS_CATEGORY2 INDEX (RDB$PRIMARY3),
EIZM INDEX (RDB$PRIMARY1),
BRAND INDEX (RDB$PRIMARY4),
GOODS_CATEGORY1 INDEX (RDB$PRIMARY3))
INTO :O_QTY_DLV1, :O_QTY_RLI1, :O_GDS_ID1, :O_GDS_CODE1, :O_GDS_NOTE1, :O_BRD_NAME1,
:O_EIZ_NAME1, :O_GDC_NAME11, :O_GDC_NAME21
|