It seems you cannot update a table, getting data from another
ie a query like :

update tableA
set tableA.datefield = tableB.datefield
where tableA.number = tableB.number

how could this be done ?