Question

ASP 查询多个表

有四个表 Computer dianqi prints zhuoyi 每个表都有 kind 字段 我是想做站内搜索 然后SQL语句怎么写出来啊

Answer 1

你现在把四种产品分别放到四个表中了，搜索我建议选择类别搜索，每选择一个类别对应一个表，这样查询会好一些，

如果你四个表的字段都一样的话，可以用union合并查询，但是，这样一样，就失去了你分成四个表的优越性了。

你自己选择吧

Answer 2

select computer.kind,dianqi.kind,prints.kind,zhuoyi.kind from computer,dianqi,prints,zhuoyi

Answer 3

select kind from computer where 条件1 UNION ALL select kind from dianqi where 条件2 UNION ALL select kind from prints where 条件3 UNION ALL select kind from zhuoyi where 条件4 order by XXX

Answer 4

select computer.kind,dianqi.kind,prints.kind,zhuoyi.kind from computer,dianqi,prints,zhuoyi

Answer 5

select computer.kind,dianqi.kind,prints.kind,zhuoyi.kind from computer,dianqi,prints,zhuoyi