-- apps_master.spUpdateSuccess_ProcessJointOrder (PROCEDURE)
begin
	UPDATE 	apps_master.m_joint_order jo
		LEFT JOIN apps_transaction.header_pre_order_joint_owner h ON jo.JointOrderID = h.JointOrderID
		LEFT JOIN apps_transaction.detail_pre_order_joint_owner d ON h.PreOrderID = d.PreOrderID
		LEFT JOIN apps_master.m_joint_order_discount di ON h.JointOrderID = di.JointOrderID
		LEFT JOIN apps_master.m_joint_order_point p ON h.JointOrderID = p.JointOrderID
		SET	d.SuccessYN = 'Y',
			h.ProcessYN = 'Y',
			h.LastUpdated = NOW(),
			h.UpdatedBy = 0,
			d.LastUpdated = NOW(),
			d.UpdatedBy = 0,
			jo.ActiveYN = 'N',
			jo.LastUpdated = NOW(),
			jo.UpdatedBy = 0,
			di.ActiveYN = 'N',
			di.LastUpdated = NOW(),
			di.UpdatedBy = 0,
			p.ActiveYN = 'N',
			p.LastUpdated = NOW(),
			p.UpdatedBy = 0
		WHERE	d.JointOrderDiscount = disc AND h.PreOrderID = id;
end