请问这条ACC的SQL如何写成VB所支持的SQL

提问者：金牌马子shy  |  浏览 次  |  提问时间：2017-03-09  |  回答数量：1

SELECT dbo_t_audit_item.audit_id, dbo_t_audit_advice.advice_cn, dbo_t_audit_defect.defect_cn, dbo_t_noname.sno_no, *FROM dbo_t_noname INNER JOIN ((dbo_t_audit_item INNER JOIN dbo_t_audit_advice ON dbo_t_audit_item.advice_id = dbo_t_audit_advice.advice_id) INNER JOIN dbo_t_audit_defect ON dbo_t_audit_item.defect_id = dbo_t_audit_defect.defect_id) ON dbo_t_noname.sno_id = dbo_t_audit_item.defect_codeWHERE (((dbo_t_audit_item.audit_id)=48));