On Sat, Aug 04, 2001 at 12:46:06AM -0700, Eric Fegraus wrote:
>
> I just checked the list for answer to this question and looks like
> there hasn't been one. I have a similar problem, I want to delete a
> record from a table where the value of the field is equal to the
> value of a field in another table.
>
> delete from table1 where table1.column = table2.column;
>
> Any thoughts?
You can't do it (yet) in MySQL. If you're using a programming
language of any sort to get to MySQL, though, it'd be trivial to do it
in 2 separate queries.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 48 days, processed 390,289,076 queries (92/sec. avg)
---------------------------------------------------------------------
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