Hello Everbody !

SQL for beginners or just to stupid ????

I have to sync to tables in maxdb

table a
*********
textid no key !!
text
...
...
...

table b
**********
textid key !!
text

if textid of table a <> ' ' i need the text of table b

i am thinking of something like this:
 
update a set text = (select text from b where b.textid = a.textid) where 
a.textid <> ' '

but i can't get it running

Any help welcomed
Best regards
Albert


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to