Update field with subquery

Posts   
 
    
Gabor
User
Posts: 97
Joined: 29-Jan-2005
# Posted on: 23-Apr-2005 11:05:19   

Frans,

Is it possible to update a field with the values filtered from another table using UpdateEnttiesDirectly?

I have two tables with 1-m relationship.

I want to update field in table2 with some filter condition, with values in table1's field, with some filter condition

In SQL:

Update table2 set field1=(select MyField from table1 where table1.someField=someValue) where table2.someField=SomeOtherValue

Thanks

Gabor

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 23-Apr-2005 11:37:31   

Not yet. This is planned for the june update.

Frans Bouma | Lead developer LLBLGen Pro