Hi all,<br><br>someone knows why this statement doesn't work?<br><br>echo "UPDATE grenzen gr SET gr.cleft=(SELECT adm.NAME FROM myadm0 amd WHERE gr.left= adm.cat)" | db.execute<br><br>I try to populate the 'cleft'-column of 'grenzen'-table with the values from the 'NAME'-column of 'myadm0'-table.<br>
<br>Thanks in advance<br><br>Manuel<br>