Hi, I am sure this is an old chestnut, but a web search has revealed no answers.
I have: table pubdata ( dkey smallint(5) unsigned NOT NULL default '0', pubkey smallint(5) unsigned NOT NULL default '0', title varchar(100) NOT NULL default '' )"; table ddata ( dkey smallint(5) unsigned NOT NULL default '0', name varchar(100) NOT NULL default '', type varchar(30) NOT NULL default '', ... ... pubkey smallint(5) unsigned NOT NULL default '0', title varchar(100) NOT NULL default '' ) 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; but guess what? it won't work! what am I doing wrong here? 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
