关于#sqlserver#的问题：sql删除语句报错

Question

DELETE company.,ebill. FROM company,ebill WHERE company.id = ebill.id AND company.id = 5;
这句sql语句为啥报错了，同时删除2张表相同id对应的行。

Answer 1

innerjoin匹配，你的语法也不是sql server的语法

DELETE company, ebill
FROM company
INNER JOIN ebill ON company.id = ebill.id
WHERE company.id = 5;