Jason Pruim wrote: > I am attempting to write a PHP application that reads info from a > MySQL database, and I'm wondering if I can set up a column in one > table that gets it's info from a field in another table automatically?
> Ie: > Table1: > field1 > field2 > field3 > Table2: > field4 > field5 > field6 = field1 All the responses have approached this as a join problem. But if you want a field in a table to equal the data in a field in another table (field6 = field1) then perhaps what you really need is a trigger on Table2 that will grab data out of Table1 on insert into Table2, or change data in Table2 on update to Table1. Jim Lyons ----- Jim Lyons MySQL DBA Hoover's, Inc. 512-380-4780 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]