Does JBEDS 5.1 support a subquery in criteria of an Update or Delete statement?

Issue

I've read that subqueries may not be supported in updates or deletes with JBEDS 5.1, and I'm looking to see when that applies or if there are any recommended workarounds.

Here is the simple query I'm using to test this which throws a left/right expression type error:

update Draft 
set Draft.DrftRecStatus='PendingSettlement' 
where Draft.Id in (select Id from DraftDetail where drftrecid='B')

When I change the where statement to not use a subquery it works fine:
```
where Draft.Id in ('820001','820002','820003','820004')
```

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.