select DEMO_ORDERS.ORDER_ID as ORDER_ID,
    DEMO_ORDERS.CUSTOMER_ID as CUSTOMER_ID,
    DEMO_ORDERS.ORDER_TOTAL as ORDER_TOTAL,
    DEMO_ORDERS.ORDER_TIMESTAMP as ORDER_TIMESTAMP,
    DEMO_CUSTOMERS.CUST_FIRST_NAME as CUST_FIRST_NAME,
    DEMO_CUSTOMERS.CUST_LAST_NAME as CUST_LAST_NAME,
    DEMO_CUSTOMERS.CUST_STREET_ADDRESS1 as CUST_STREET_ADDRESS1,
    DEMO_CUSTOMERS.CUST_CITY as CUST_CITY,
    DEMO_CUSTOMERS.CUST_EMAIL as CUST_EMAIL 
 from DEMO_CUSTOMERS DEMO_CUSTOMERS,
    DEMO_ORDERS DEMO_ORDERS 
 where DEMO_ORDERS.CUSTOMER_ID=DEMO_CUSTOMERS.CUSTOMER_ID and DEMO_ORDERS.ORDER_ID=:P29_ORDER_ID