我的表Reply有Rid,Rcontents,Rtime,Cid,Rtime,Uid这些字段,Reverts有RRid,RRcontents,Rtime,Cid,Rtime,Uid,Rid这些字段。其中Rid和RRid分别是他们的ID值,我现在要把他们的Rcontents和RRcontents放在同一个属性contents中,两个Rtime放在time属性中,Cid放Cid中,Uid放Uidz中,这个怎么用SQL语句来实现呢?求解啊。。
调试欢乐多
必须保证前后字段名称。数目。数据类型一致select rid as id,rcontents as contents,rtime as time from reply
union
select rrid as id,rcontents as contents,rrtime as time from reverts
必须保证前后字段名称。数目。数据类型一致select rid as id,rcontents as contents,rtime as time from reply
union all
select rrid as id,rcontents as contents,rrtime as time from reverts
如果你是用adapter的话 adapter.Fill(mydataset)
mydataset.datatable[0]就是你要找的表。直接绑定数据控件就行了
union all
select rrid as id,rcontents as contents,rrtime as time from reverts
把他当做一个sql,查询数据库,得到一个datatable,然后绑定到控件上就行了。不用给名字。
(select rid as id,rcontents as contents,rtime as time from reply
union all
select rrid as id,rcontents as contents,rrtime as time from reverts) as t