When I issued the following command
UPDATE tab1 SET field1=(SELECT fstreet FROM tab2)
I got the error "cannot insert the value NULL into column 'field1'"
The table structures are built by a commercial ERP so they cannot be changed. How can I do?