problem with delete query

[r]

I am trying to do a delete query like this one:

DELETE FROM pending WHERE pages.url=pendi ng.url AND
pages.date=pend ing.date;

If I run it (via PHP) I get the following error: Unknown table 'pages'
in where clause.

What I am actually trying to do is that I want to delete a record from
the table "pending" where the fields url and date (the combination) in
both tables are the same.

Both the tables pages and pending do exist.
If I look in the MySQL manual I see this example:

DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id

Which looks pretty much on the query I try to do.

Does anybody see what I am doing wrong? And what I should do to make
this work?

Thanks in advance!

Wim

[Aggro]

r wrote:

I am trying to do a delete query like this one:

DELETE FROM pending WHERE pages.url=pendi ng.url AND
pages.date=pend ing.date;
Your query looks like this:
delete from t1 where t2.url=t1.url and t2.date=t1.date ;
DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id

Which looks pretty much on the query I try to do.

No it doesn't.

This would look like the example:

delete t1,t2 from t1,t2 where t2.url=t1.url and t2.date=t1.date ;

But you propably want to delete only from the t1 table, so I think the
query would be:

delete t1 from t1,t2 where t2.url=t1.url and t2.date=t1.date ;

Don't test this with valuable material since I have never done
multitable delete queries and I'm not sure whether this removes material
from t1 or both t1 and t2. This was more like a wild quess how it should
be. I'm in a bit hurry so I don't have to test it myself now. Please
tell if it worked or not.

[Aggro]

r wrote:

I am trying to do a delete query like this one:

DELETE FROM pending WHERE pages.url=pendi ng.url AND
pages.date=pend ing.date;
Your query looks like this:
delete from t1 where t2.url=t1.url and t2.date=t1.date ;
DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id

Which looks pretty much on the query I try to do.

No it doesn't.

This would look like the example:

delete t1,t2 from t1,t2 where t2.url=t1.url and t2.date=t1.date ;

But you propably want to delete only from the t1 table, so I think the
query would be:

delete t1 from t1,t2 where t2.url=t1.url and t2.date=t1.date ;

Don't test this with valuable material since I have never done
multitable delete queries and I'm not sure whether this removes material
from t1 or both t1 and t2. This was more like a wild quess how it should
be. I'm in a bit hurry so I don't have to test it myself now. Please
tell if it worked or not.