UC知道怎么样才能在搜索功能中调用同个数据库中的两个表
来源：百度知道 编辑：UC知道 时间：2024/09/24 20:35:09
<%
dim mc
mc=request("mc")
Set rs=Server.CreateObject("adodb.recordSet")
sql="select * from [cp] where mc like '%"&mc&"%' order by ID desc"%>
<table border="0" cellpadding="2" width="100%">
<%
rs.open sql,conn,1,1
if rs.recordcount<>0 then
do while not rs.eof
%>
比如我在搜索功能中既想调用[cp]这个表，又想调用[cp1]这个表，正确的该怎么写
试过了不行啊，我原来是这样写的，现在我想加上[cp]该怎么写，急急
sql="select * from [cp1] where bh like '%"&mc&"%'or mc like '%"&mc&"%' or ty like '%"&mc&"%'or sy like '%"&mc&"%'order by ID desc"%>
dim mc
mc=request("mc")
Set rs=Server.CreateObject("adodb.recordSet")
sql="select * from [cp] where mc like '%"&mc&"%' order by ID desc"%>
<table border="0" cellpadding="2" width="100%">
<%
rs.open sql,conn,1,1
if rs.recordcount<>0 then
do while not rs.eof
%>
比如我在搜索功能中既想调用[cp]这个表，又想调用[cp1]这个表，正确的该怎么写
试过了不行啊，我原来是这样写的，现在我想加上[cp]该怎么写，急急
sql="select * from [cp1] where bh like '%"&mc&"%'or mc like '%"&mc&"%' or ty like '%"&mc&"%'or sy like '%"&mc&"%'order by ID desc"%>
联合查询
sql="select * from [cp1] where bh like '%"&mc&"%'or mc like '%"&mc&"%' or ty like '%"&mc&"%'or sy like '%"&mc&"%'order by ID desc union select * from [cp] where mc like '%"&mc&"%' order by ID desc"
不过要求两张表的结构要是相同的
sql="select [cp].* from [cp],[cp1] where [cp].id=[cp1].id and [cp].mc like '%"&mc&"%' order by [cp].ID desc"