update TousseInstance set operationRoomName=(select OperationRoom from UseRecord where id=TousseInstance.useRecord_id) where useRecord_id is not null; update TousseInstance set operationRoomName=(select ip.operationRoom from Invoice i join invoicePlan ip on ip.id=i.invoicePlan_ID where i.id=TousseInstance.invoice_id) where invoice_id is not null and useRecord_id is null;