Hello, I'm a newbie, so pardon my lack of wherewithal with MySQL, and thanks
for the help in advance.
I have two table and I want to copy info from one table to another. I can
pull the correct information out with a select statement that looks
something like this
Select x1 from tbl1, tbl2 where y1 = y2
(numbers correspond to different tables)
This returns a table of the info I want to use. Logically, what I would
like to do is:
Update tbl1 set x1 = x2 where y1 = y2;
But this won't work because x1 and x2 are from different tables, as are y1
and y2. However, I've tried including tbl2 in the update parts, and that
doesn't work either. I'm at a loss.
Thanks for any help.
-eric spletzer
---------------------------------------------------------------------
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
