Hi, I am using MySql Ver ll.15 distrib. 3.23.41
I want to write an sql query something like: update ddata set ddata.pubkey = pubdata.pubkey, ddata.title=pubdata.title where ddata.dkey=pubdata.dkey; This generates an error: ERROR 1109: Unknown table 'pubdata' in where clause and using this: update ddata set ddata.pubkey = pubdata.pubkey and set ddata.title=pubdata.title where ddata.dkey=pubdata.dkey; generates the error: ERROR 1064: You have an error in your SQL syntax near 'set ddata.title=pubdata.title where ddata.dkey=pubdata.dkey' at line 1 So that didn't work either. Donna --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
