Hi all, I am new in mysql and want to analyse between some popular databases. I have a SQL:
update ta set f1 = ( select af1 from tb where ta.id = tb.id ); It can be done in postgreSQL and Oracle. How can I do the same tasks in MySQL without using Perl? Is it possible to do this tasks just enter the SQL statement? Kenenth. --------------------------------------------------------------------- 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