Codeigniter 通过连接表删除数据

从逻辑上讲，在 SQL 中，我们可以使用 JOINS 从表中删除数据，例如

DELETE  clb_subscriber_group_mapping .* FROM clb_subscriber_group_mapping 
INNER JOIN clb_driver_group ON (clb_driver_group.id = clb_subscriber_group_mapping.driver_group_id)
INNER JOIN clb_company ON (clb_company.id = clb_driver_group.company_id)
WHERE clb_company.id = 256 AND clb_subscriber_group_mapping.subscriber_id = 1784;

上述查询的 CodeIgniter 等价物是什么？

CodeIgniter 是否支持带有连接的删除查询？

Do you have to use 活动记录 http://codeigniter.com/user_guide/database/active_record.html?

下面这个query http://codeigniter.com/user_guide/database/queries.html否则就会做。

$int_company_id = 256;
$int_subscriber_id = 1784;

$this->db->query("
DELETE  clb_subscriber_group_mapping .* FROM clb_subscriber_group_mapping 
INNER JOIN clb_driver_group ON (clb_driver_group.id = clb_subscriber_group_mapping.driver_group_id)
INNER JOIN clb_company ON (clb_company.id = clb_driver_group.company_id)
WHERE clb_company.id = ? AND clb_subscriber_group_mapping.subscriber_id = ?;

", array($int_company_id, $int_subscriber_id));