Thanks for this response, it is one way round the problem but is going to require copying the tables, some of them very large a number of times over and over. Is their no way of simply adding the data alongside the existing columns?
Alex ---------------------------------------------- Alexander Shaw Agricultural Stock and Assignment Photography > -----Original Message----- > From: Sabine Richter [mailto:[EMAIL PROTECTED]] > Sent: 17 May 2002 23:12 > To: [EMAIL PROTECTED] > Subject: [Fwd: Add existing related data to a table] > > > Sorry, > I've been too long in a list where you just answer the questioner and > then the questioner writes a summary of the answers to the list. > Sabine > > Sabine Richter wrote: > > > > Hello Alexander, > > > > your problem is near to Taylor Lewick's and I have a similar suggestion > > for you: > > > > 1) create newtab > > select tableA.*, tableB.SubcatID > > from tableA.*, tableB > > where ... > > 2) delete tablea > > 3) rename table newtab to tablea > > > > If there are more rows in tableB (1:n), you don't loose data. The data > > of tabA > > will be dublicated. > > > > Ok, that are 3 statements. > > > > Bye > > Sabine > > > > Alexander Shaw wrote: > > > > > > Hi, > > > > > > I'm looking for some suggestions of making a one time update > to some of my > > > tables to make them useable with new forms and queries I'm > creating. I have > > > a series of tables which hold related data and only the last > part of the > > > data is stored in a final table, which means to search data based on > > > > > > some of the information higher up the table structure is > making some very > > > complex and dodgy queries. > > > > > > I want to insert the related data into the final table but > can't think of a > > > way of doing it. The example below might help me explain > better what I mean. > > > > > > Consider two tables - TableA which contains PicID and KeywordID > > > > > > TableB which contains > SubcatID and KeywordID > > > > > > What I want to do is insert the corresponding values for relating to > > > KeywordID for SubCatID into a new column in TableA. > > > > > > Any suggestions how to work this to add the extra information > to existing > > > records? > > > > > > Alex > > > > > > ---------------------------------------------- > > > > > > Alexander Shaw > > > Agricultural Stock and Assignment Photography > > > > > > p.s. to get throught he spam trap - sql query > > > > > > --- > > > Outgoing mail is certified Virus Free. > > > Checked by AVG anti-virus system (http://www.grisoft.com). > > > Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/2002 > > > > > > --------------------------------------------------------------------- > > > 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 > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/2002 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.360 / Virus Database: 199 - Release Date: 07/05/2002 --------------------------------------------------------------------- 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
