Updating Master table information based on Detail table status I have one master and one detail table as following

Master:-
   BatchID
   BatchStatus
Detail
   DetailID
   BatchID
   DetailRecordStatus (Possible values 1,2,3)


I am trying to write a single a query that can update the Batch Status in Master based on detailRecordStatus values equal to 2 or 3
Have you tried Update with join? 

For example..

UPDATE TABLE1
JOIN TABLE2
ON TABLE1.SUBST_ID = TABLE2.SERIAL_ID
SET    TABLE2.BRANCH_ID = TABLE1.CREATED_ID
WHERE TABLE2.BRANCH_ID IS NULL