On Mon, Mar 15, 1999 at 07:23:02PM -0500, efrazier@stripped wrote:
> DELETE books.*, fbooks.*, sbooks.*
> FROM books,fbooks, sbooks
> WHERE books.index=fbooks.index
> AND
> books.index =3;
Nope, you can only delete from one table at a time. You can't
reference other tables (do joins) even if you're only trying to
delete from one table. Once MySQL has sub-selects, the desire
to do that will go away (for now join the ids together in a
comma-separated string and delete WHERE id IN (ids-string)).
But for you, just do three separate deletes. If you don't like
it, you'll probably have to use something other than SQL. :)
Tim
