i need help to right a select and update query's. i need to join 3 tables in single update query (order_line_item,item_cbo and orders).
below one i prepared but still i am getting error (sql query not properly end) please help me to right correct update query.
update order_line_item OLI
set OLI.std_bundle_qty = (select ic.std_bundl_qty from item_cbo ic where OLI.item_id = ic.item_id )
Join orders os on OLI.order_id = os.order_id
WHERE OLI.item_name = '987654'
and OLI.order_id ='1234567'
and OLI.do_dtl_status = '110';