Hi,

I would like to know how to create a field that comes from another table and
how to insert values from a table into another one.

kind of like this

table_1
uid1 ...(primary key)
first_name ...
last_name ...

craete table table_2 (
uid2...(primary key)
phone...
fax...
table_1.uid1 ...);

insert into table_2
(phone,fax,???????)
values
("999-9999", "555-5555", ????????);

Please replace the ???????......................thanx




---------------------------------------------------------------------
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

Reply via email to