If you want the two tables to remain separate, for normalization purposes, you can use JOINs:
SELECT * FROM tableA LEFT JOIN tableB USING(id); The above statement will retrieve all the information for each id in both tables. Yet, the tables may be managed separately. This is especially valuable to prevent wasted space. For example, tableA may have thousands of rows, but tableB has only a few which are "connected" to tableA via the "id" field. -----Original Message----- From: P.Agenbag [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 4:58 PM To: mysql Subject: duplicating collumn Hi I have two tables, one contains a persons name and an ID number. The other table contains the ID number and another field. Is there a way of moving this collumn to the first table to corrlate with the ID's, ie, table 1 must now contains name, ID and another field that is specific to the person. The two tables are not chronological ie. the 1st entry in the one table is not nescessarily the first in the second table... --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
