请问一下MySQL如何删除union联合查询两个表出来的数据？谢谢$sql = "SELECT (@rowNO := @rowNo+1) AS rowno,a.* FROM
(SELECT huishou.id,huishou.status,huishou.ctime,huishou.uid AS huishouid ,huishou.name AS username,huishou.mobile AS usertel,place.name AS countyname, place2.name AS streetname, xiaoqu.name AS `xiaoquname`,address AS `useraddress` FROM ims_delixin_orderrecycling AS huishou
LEFT JOIN ims_delixin_place AS place ON huishou.county=place.id
LEFT JOIN ims_delixin_xiaoqu AS xiaoqu ON huishou.community=xiaoqu.id
LEFT JOIN ( SELECT * FROM ims_delixin_place WHERE `level`=2 ) place2 ON huishou.street=place2.id
UNION ALL
SELECT laji.id,laji.status,laji.ctime,laji.uid AS lajiid ,laji.name AS username,laji.mobile AS usertel,place.name AS countyname, place2.name AS streetname, xiaoqu.name AS `xiaoquname`,address AS `useraddress` FROM ims_delixin_orderrubbishbag AS laji
LEFT JOIN ims_delixin_place AS place ON laji.county=place.id
LEFT JOIN ims_delixin_xiaoqu AS xiaoqu ON laji.community=xiaoqu.id
LEFT JOIN ( SELECT * FROM ims_delixin_place WHERE `level`=2 ) place2 ON laji.street=place2.id) a,
(SELECT @rowNO :=0) b";
$article = pdo_fetchall( $sql );$id = intval($_GPC['id']);
$sql = "delete from ********* where id=$id";
$result = pdo_query( $sql );请问一下删除语句该怎么写呢？最佳答案
