a guest Oct 12th, 2017 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT * FROM ZBCVT_PRD_PRC_HI AS pp INNER JOIN zbcvt_product AS p ON pp~product_id = p~product_id
- INTO CORRESPONDING FIELDS OF TABLE it_products
- WHERE pp~history_date = ( SELECT MAX( history_date ) FROM ZBCVT_PRD_PRC_HI WHERE product_id = p~product_id ).
RAW Paste Data