select DEMO_ORDER_ITEMS.ORDER_ID as ORDER_ID,
    DEMO_ORDER_ITEMS.PRODUCT_ID as PRODUCT_ID,
    DEMO_ORDER_ITEMS.UNIT_PRICE as UNIT_PRICE,
    DEMO_ORDER_ITEMS.QUANTITY as QUANTITY,
    DEMO_PRODUCT_INFO.PRODUCT_NAME as PRODUCT_NAME,
    DEMO_PRODUCT_INFO.PRODUCT_DESCRIPTION as PRODUCT_DESCRIPTION,
    DEMO_ORDER_ITEMS.ORDER_ITEM_ID as ORDER_ITEM_ID 
 from DEMO_PRODUCT_INFO DEMO_PRODUCT_INFO,
    DEMO_ORDER_ITEMS DEMO_ORDER_ITEMS 
 where DEMO_ORDER_ITEMS.PRODUCT_ID=DEMO_PRODUCT_INFO.PRODUCT_ID
and DEMO_ORDER_ITEMS.ORDER_ID=:P29_ORDER_ID