SELECT title, times FROM item1 WHERE title LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%' Union all (SELECT title, addtimes as times FROM item2 WHERE title LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%' order by ....写times?addtimes?怎么写?
(
SELECT title, times FROM item1 WHERE title LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%'
Union all
(SELECT title, addtimes as times FROM item2 WHERE title LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%'
) t
order by times,addtimes
(
SELECT title, times FROM item1 WHERE title LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%'
Union all
(SELECT title, addtimes as times FROM item2 WHERE title LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%'
) t
order by times