สอบถามปัญหาเรื่อง Subquery ใน Where ของ UPDATE ครับ

UPDATE bring SET 
se_id = '0000000001', 
b_st = '2', 
b_dateapprove = now(), 
b_see = '1', 
d_no = (SELECT MIN(d_no) FROM durables WHERE d_id = 'D00001' AND d_bring = '1') 
WHERE bring.b_id = 'B00001' AND 
bring.b_no = '1' AND 
bring.d_id = 'D00001' AND 
bring.d_no = (SELECT MIN(d_no) FROM bring WHERE b_id = 'B00001' AND b_no = '1' AND d_id = 'D00001')