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