It's not possible to do in one step in MySQL.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
"roger westin" <[EMAIL PROTECTED]> wrote:
So a question....
I have two tables. And i want to... (i just show you)
Table 1.
Owner Char(30) Uniqe
File Char(80)
OID int (not in use yet)
Table 2.
ID int uniqe and so on
Owner Char
Name Char
adress
etc
....
So I want to give the OID in table 1 the corresponding ID from Table 2 so
that I may remove The Owner Col.
I can do it with using tmp tables and so on, ( my knowlage in SQL querys is
wery limited), But I want to do it
with Just ONE singel SQL line....
Any ideas?
/roger
---------------------------------------------------------------------
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
