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 Taylor, > > as far as I see from the documentation and own trials you can just > delete from table where conditions_of_this_table. > So you can not delete values matching a temp table. > But I think I have a possible workaround for you: > > 1: create a new table with the opposite of your question, i.e. the rows > both tables have in common: > --> create table interim select table1.* > from table1, table2 where table1.ticker_name = table2.ticker_name; > 2. delete table1 > 3. rename table interim to table1 > > I think that will do what you want. > > Bye > Sabine > > Taylor Lewick wrote: > > > > How can I delete from a table the results of a join query.. > > > > I.e, join two tables together, get the resutls, now want to delete that data from >one of the tables... > > Do I have to create a tempory table, hold the data, and delete from the one table >data matching in the temp table, > > or can I just combine a delete statement with my original query...? > > > > here is my query, which works.. > > > > select distinct table1.ticker_name > > from table1 LEFT JOIN on table2 on (table1.ticker_name = table2.ticker_name) > > where table2.ticker_name IS NULL; > > > > Thanks, > > Taylor > > > > Taylor Lewick > > Unix System Administrator > > Fortis Benefits > > 816 881 6073 > > > > "Help Wanted. Seeking Telepath..." > > "You Know where to apply." > > > > **************************************************************** > > Please Note > > The information in this E-mail message is legally privileged > > and confidential information intended only for the use of the > > individual(s) named above. If you, the reader of this message, > > are not the intended recipient, you are hereby notified that > > you should not further disseminate, distribute, or forward this > > E-mail message. If you have received this E-mail in error, > > please notify the sender. Thank you > > ***************************************************************** > > > > --------------------------------------------------------------------- > > 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