我写了个两表联查语句
SELECT dbo.FieldValue.UId, dbo.FieldValue.FieldId, dbo.FieldValue.[Content], dbo.userPower.powerid
FROM dbo.FieldValue INNER JOIN dbo.userPower
ON dbo.FieldValue.FieldId = dbo.userPower.fieldid
and dbo.userPower.powerid <> 1
查出来很多重复数据,只想保存一条记录,不知道该怎么办,请各位指点下。谢谢!
我查询的结果显示为:
----------------------------------------------------------------------------
UId FieldId Content powerid
3 1 wangjingru 2
3 1 wangjingru 2
3 2 WJR 3
3 2 WJR 3
3 3 [email protected] 3
3 3 [email protected] 3
怎样显示为:
----------------------------------------------------------------------------
UId FieldId Content powerid
3 1 wangjingru 2
3 2 WJR 3
3 3 [email protected] 3各位请指点下,谢谢!
SELECT dbo.FieldValue.UId, dbo.FieldValue.FieldId, dbo.FieldValue.[Content], dbo.userPower.powerid
FROM dbo.FieldValue INNER JOIN dbo.userPower
ON dbo.FieldValue.FieldId = dbo.userPower.fieldid
and dbo.userPower.powerid <> 1
查出来很多重复数据,只想保存一条记录,不知道该怎么办,请各位指点下。谢谢!
我查询的结果显示为:
----------------------------------------------------------------------------
UId FieldId Content powerid
3 1 wangjingru 2
3 1 wangjingru 2
3 2 WJR 3
3 2 WJR 3
3 3 [email protected] 3
3 3 [email protected] 3
怎样显示为:
----------------------------------------------------------------------------
UId FieldId Content powerid
3 1 wangjingru 2
3 2 WJR 3
3 3 [email protected] 3各位请指点下,谢谢!
解决方案 »
- AjaxControltoolkit控件只能用在AjaxControlToolkit的网站中吗?
- 如何截取本页的流,访问a.aspx的同时在服务器上生成一个静态a.htm?
- MagicAjax 里面无法使用 response.write()?
- 为什么别人不能访问我机器上的asp.net网站呢,我在自己机器上访问没有问题
- 急,請各們高手指教,為什么每次PostBack時Page_Load都會執行兩次?
- 一个多年没解的小问题
- 在ASP。NET里,如何捕获访问者的IP和他所用的浏览器属性
- 一个有点意思的问题,希望大家进来看看
- 帮忙看看datalist里这句判断 有什么错误 就是运行不了
- 关于用DataGrid显示数据库内容的小问题
- 如何拼接参数化的SQL语句???
- asp.net sql分页
FROM dbo.FieldValue INNER JOIN dbo.userPower
ON dbo.FieldValue.FieldId = dbo.userPower.fieldid
and dbo.userPower.powerid <> 1
FROM dbo.FieldValue INNER JOIN dbo.userPower
ON dbo.FieldValue.FieldId = dbo.userPower.fieldid
and dbo.userPower.powerid <> 1