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
