select * from
(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
用union
必须保证前后字段名称。数目。数据类型一致
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
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
把他当做一个sql,查询数据库,得到一个datatable,然后绑定到控件上就行了。不用给名字。
用union
必须保证前后字段名称。数目。数据类型一致
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