CREATE VIEW view_orderbooklist AS
SELECT
ol.seqno AS seqno,
ol.order_no AS order_no,
ol.cid AS cid,
ol.isbn AS isbn,
ol.seller_no AS seller_no,
ol.norm_pub AS norm_pub,
ol.series_no AS series_no,
ol.status AS status,
ol.list_price AS list_price,
ol.dc_rate AS dc_rate,
ol.sell_price AS sell_price,
ol.buy_price AS buy_price,
ol.order_count AS order_count,
ol.work_seqno AS work_seqno,
ol.order_seqno AS order_seqno,
ol.created AS created,
ol.remarks AS remarks,
st.stock AS stock
FROM orderbooklist ol, book_stock st
WHERE ol.isbn=st.isbn