我没有办法纠正准确的错误。这就是为什么把它张贴在这里。我有estimation_id。我想删除bill表,也就是bill_details table.In bill_details tbl,还有bill_id stored.So,我编写了一个查询,以便从bill tbl.But中进行选择where estimation=in_estimation_id;
DELETE FROM bill WHERE e
SELECT bill.[cust_id], MONTH(bill.[del_date]), YEAR(bill.[del_date]), ORDER BY YEAR(bill.[del_date]), MONTH(bill.[del_date])) AS QtyProcessed
FROM EnvelopeBill