請問這條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));