| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.11.5 |
| Request #3425 | Delete + Inner Join | ||
|---|---|---|---|
| Submitted: | 2005-02-10 16:19 UTC | ||
| From: | sylfradev at yahoo dot fr | Assigned: | |
| Status: | Suspended | Package: | DB_DataObject |
| PHP Version: | 4.3.3 | OS: | Windows 200 |
| Roadmaps: | (Not assigned) | ||
[2005-02-10 16:19 UTC] sylfradev at yahoo dot fr
Description:
------------
When you add joins with joinAdd, they are not used in DELETE queries, whereas they work with SELECT queries
Expected result:
----------------
This should produce a query like that :
DELETE FROM X USING X INNER JOIN Y ON X.a=Y.a
whereas it gives :
DELETE FROM X
So I have to use :
$factory->query("DELETE FROM ". $factory->tableName()
. " USING " . $factory->tableName()
. " " . $factory->_join
. " " . $factory->_query['condition']);