以下内容为程序代码:
"SELECT m_1.name,m_1.remark FROM m_1 UNION ALL select m_22.name,m_22.remark FROM m_22 UNION ALL select m_big.m_big,m_big.remark FROM m_big UNION ALL select m_m1.m_m1,m_m1.remark FROM m_m1 UNION ALL select m_m2.m_m2,m_m2.remark FROM m_m2 UNION ALL select m_s.m_s,m_s.remark FROM m_s UNION ALL select m_s2.M_s,m_s2.remark FROM m_s2 UNION ALL select p_big.m_big,p_big.remark FROM p_big UNION ALL select p_m1.m_m1,p_m1.remark FROM p_m1 UNION ALL select p_m2.m_m2,p_m2.remark FROM p_m2 UNION ALL select p_s.m_s,p_s.remark FROM p_s WHERE m_1.name like '%" + Replace(rs1__mm_t, "'", "''"
+ "%'"
代码结束
提示错误为
引用：
--------------------------------------------------------------------------------
Microsoft OLE DB Provider for SQL Server 错误 '80040e14'
The column prefix 'm_1' does not match with a table name or alias name used in the query.
/dictionary/schd.asp，行20
--------------------------------------------------------------------------------
以下内容为程序代码:
"SELECT m_1.name,m_1.remark FROM m_1 UNION ALL select m_22.name,m_22.remark FROM m_22 UNION ALL select m_big.m_big,m_big.remark FROM m_big UNION ALL select m_m1.m_m1,m_m1.remark FROM m_m1 UNION ALL select m_m2.m_m2,m_m2.remark FROM m_m2 UNION ALL select m_s.m_s,m_s.remark FROM m_s UNION ALL select m_s2.M_s,m_s2.remark FROM m_s2 UNION ALL select p_big.m_big,p_big.remark FROM p_big UNION ALL select p_m1.m_m1,p_m1.remark FROM p_m1 UNION ALL select p_m2.m_m2,p_m2.remark FROM p_m2 UNION ALL select p_s.m_s,p_s.remark FROM p_s WHERE
name like '%" + Replace(rs1__mm_t, "'", "''"
+ "%'"
代码结束
提示错误为：
引用：
--------------------------------------------------------------------------------
Microsoft OLE DB Provider for SQL Server 错误 '80040e14'
Invalid column name 'name'.
/dictionary/schd.asp，行20
--------------------------------------------------------------------------------
我该如何改？
