I wanted to update a table with the value from another table but I'm running with an older version of mysql (version 3.27) UPDATE coop_warehouse, tst_coop_warehouse SET coop_warehouse.sort_key = tst_coop_warehouse.sort_key WHERE coop_warehouse.warehouse_code = tst_coop_warehouse.warehouse_code; is what I want but can't seem to figure it out. It's not big table so I can figure a work around, but it would be nice to know the syntax. Pat www.gypsyfarm.com
[Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
