mysql删除 别名错误

这样删除报错误

 $elementSql = "DELETE  FROM " . $CFG['tb_pre'] . "elements e," . $CFG['tb_pre'] . "decompose d WHERE d.project_id=" . $projectid . " AND d.id=e.decompose_id"; 

修改如下：

$elementSql = "DELETE e.* FROM " . $CFG['tb_pre'] . "elements e," . $CFG['tb_pre'] . "decompose d WHERE d.project_id=" . $projectid . " AND d.id=e.decompose_id";