HP c-tree-SQL ISQL and Tools manual Isql RUN

ISQL and Tools

( orders.order_id = lots.order_id ) and

( ( customers.customer_name = 'Ship Shapers Inc.' ) AND ( lot_staging.start_date is not NULL ) AND

( lot_staging.end_date is NULL ) )

ISQL> RUN

SELECT customers.customer_name, orders.order_info, orders.order_state, lot_staging.lot_location, lot_staging.start_date

FROM customers, orders,

lots, lot_staging

WHERE ( customers.customer_id = orders.customer_id ) and ( lots.lot_id = lot_staging.lot_id ) and

( orders.order_id = lots.order_id ) and

( ( customers.customer_name = 'Ship Shapers Inc.' ) AND ( lot_staging.start_date is not NULL ) AND

( lot_staging.end_date is NULL ) )

3-28 FairCom Corporation