IBM: DB2 - Update statement on join - Tek-Tips Forums

INNER JOIN (SELECT v_id,vi_id,cost_zone, store_id,MAX(vc_start_date) AS MAX_vc_start_date FROM vendor_cost ... I'm still reading up the documentation on DB2 so hopefully I'll find an answer but any input would be very appreciated if you see a big shinny .

www.tek-tips.com