>
> imho, the fact that mysql does not support joins in UPDATE and DELETE
> statements is by far its greatest weakness. I have posted a couple of
> messages to this group to see what creative work-arounds others
> have used to
> fill this gaping hole in functionality. Alas, no one has felt
> like sharing
> their thoughts on this subject.
>
Will (and Phil)
I think no-one's replied because the answer is really simple - create a
recordset using Select for the records you are interested in (using your
joins), then use that recordset to perform your UPDATE or DELETE. I have to
deal with the same situation Phil describes quite often, but I've never
missed the 'join in update' function. Not that it wouldn't be nice, but the
workaround is not rocket surgery.
Jay Fesco
---------------------------------------------------------------------
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
