delete 语句找不到字段，是不是应该用连结，帮写下
delete 语句找不到字段，是不是应该用连结，帮写下

C/C++ code

int a=sql.query("delete from lsb_qcmc where \
              销售表.名称 = lsb_qcmc.MC  AND \
              进货表.名称 = lsb_qcmc.MC  ");

------解决方案--------------------
delete from lsb_qcmc where 销售表.名称 = lsb_qcmc.MC AND 进货表.名称 = lsb_qcmc.MC 
这两个表在哪儿？