Hello,
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?
Thanks,
Eric
-----Original Message-----
From: Jeremy Morano [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 1:30 PM
To: [EMAIL PROTECTED]
Subject: Delete
Hi, im trying to delete a record from a table where the value of a field
must be equal to the value of a field of another table.............I
know
this is wrong but I need to show you what I mean. I think I'm missing a
very
important select statement to join them...........................can
anyone
help me out?
Delete from table1 where table1.value = table2.value
---------------------------------------------------------------------
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