我现在用DW做一论文查询网站，需要做连表查询，就是比如说论文名、作者、年份可以分别限定的，请问大家怎么实现？只实现一种的我会做，就是几种一起限定就不会了...
qq:4823862交流～或Email：zhizhi0429.student@sina.com

select * from lunwen where title=&request("title")& and writer=&request("writer")& and nianfen=&request("nianfen")

[quote][b]下面引用由[u]orphen1758[/u]在 [i]2003/05/14 12:11pm[/i] 发表的内容：[/b] select * from lunwen where title=&request("title")& and writer=&request("writer")& and nianfen=&request("nianfen") [/quote] select * from lunwen where 1=1 if title<>"" then sql = sql &" and title = '" & title &"'" end if ......(有多少查询条件就写多少个这样的语句)