What syntax for MySQL should I be looking at to solve a problem like the following:
3 Tables (oversimplified to show the problem area)
individual.id individual.name
individual_addresses.individual_id individual_addresses.address_id
address.id address.street
Although the structure is normalized, there is only ever one address for an individual (that this system tracks), so the address information needs to be moved to new fields in the individual table. The result would be that all addresses would reside in the individual table and the individual_addresses and the address tables would be dropped. For this example, the individual table would have a field added called individual.street.
The problem:
How can a write a statement in MySQL 4.0.12 that will move address.street data into individual.street?
Thanks!
Chris Fowler
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
