<%
'读出数据库
dim myconn,connstr,rs,sql,i
Set myconn=Server.CreateObject("ADODB.Connection")
connstr="Driver={SQL server};Server=sm;Database=110date;UID=sa;PWD=005"
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from smaj,hlfjaj where smaj.date='2006-6-1' and hlaj.date='2006-6-1'"
myconn.open connstr
rs.open sql,myconn,3,3 while (not rs.eof)
response.write rs("dq")
rs.movenext()
wend
%> 数据库里有两张表smaj,hlaj,表里的字段是相同,经过上述查询后,如何才能只读出smaj里的字段?谢谢
'读出数据库
dim myconn,connstr,rs,sql,i
Set myconn=Server.CreateObject("ADODB.Connection")
connstr="Driver={SQL server};Server=sm;Database=110date;UID=sa;PWD=005"
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from smaj,hlfjaj where smaj.date='2006-6-1' and hlaj.date='2006-6-1'"
myconn.open connstr
rs.open sql,myconn,3,3 while (not rs.eof)
response.write rs("dq")
rs.movenext()
wend
%> 数据库里有两张表smaj,hlaj,表里的字段是相同,经过上述查询后,如何才能只读出smaj里的字段?谢谢
之前你写的是有问题的
http://jay.pepsi.163.com/article.jsp?id=16255
点击"我也要帮他评分" 用163邮箱登陆 给我评分
我还差几票
,应当是两个表date='2006-6-1'的记录 的笛卡尔积