A表:字段
username,pass,sex,email,website,regtime
B表:字段
postid,parentid, username,subject,regtime,message
求一个SQL语句从两个表中查找数据
(这里设计到了GridView控件:)实现下列大致效果:
------------------------------------------------
subject username regtime website email -----------------------------------------------
把相应的数据分别绑定在对应的列上!
username,pass,sex,email,website,regtime
B表:字段
postid,parentid, username,subject,regtime,message
求一个SQL语句从两个表中查找数据
(这里设计到了GridView控件:)实现下列大致效果:
------------------------------------------------
subject username regtime website email -----------------------------------------------
把相应的数据分别绑定在对应的列上!
strSql=select postid subject,B.username,B.regtime,website,email form B,A where B.username=A.username and parentid=0 order by newpost.regtime desc
怎么改正一下??
select subject,A表.username,A表.regtime,A表.website,A表.email from
B表inner join A表 on A表.username = B表.username
order by subject
一下我是这么写但是总出错:
strSql=select postid subject,B.username,B.regtime,website,email form B,A where B.username=A.username and parentid=0 order by newpost.regtime desc
怎么改正一下??
-------------------------------------------------------
不知道搂主你的newpost.regtime newpost是什么>?如果字段名在多个表有出现的话是需要加表明限制的,建议楼主用关联查询,会好些吧!
from B b1,A a1
where b1.username=a1.username and b1.parentid=0 order by b1.regtime desc--楼主还有个错误from 写成了form,
strSql=select B.subject,B.username,A.regtime,A.website,A.email
from B,A
where B.username=A.username and parentid=0
order by A.regtime desc
from B left join A on (a.username=b.username)
order by A.regtime desc