请帮我写一个搜索的东东

[hencai]

表一：ID int,标题int，内容text
表二：ID int,标题int，内容text
表三：ID int,标题int，内容text
表四：ID int,标题int，内容text
………

请问怎样用asp把这若干表做成如下

搜索“按标题”，把表一、表二…等等的标题列的内容全部搜索出来。并且15条记录分页。
搜索“按内容”，把表一、表二…等等的内容列的内容全部搜索出来。并且15条记录分页。

[gmlxf]

-- try using "union all"
select top 15 * from
(
select * from t1
union all
select * from t2
union all
select * from t3
....
union all
select * from tn
) a where 标题=10

select top 15 * from
(
select * from t1
union all
select * from t2
union all
select * from t3
....
union all
select * from tn
) a where 内容 like '%aaa%'

[Ouyangyifeiczy]

-- try using "union all"
select * from
(
select * from t1
union all
select * from t2
union all
select * from t3
....
union all
select * from tn
) a where 标题=10

select * from
(
select * from t1
union all
select * from t2
union all
select * from t3
....
union all
select * from tn
) a where 内容 like '%aaa%'

在ASP中用rs.rowspage分页,自己控制.具体参考ADO中记录集帮助.

[hencai]

多谢，顺便问一下，怎么给分？