select id,title,info,author from dt1 where id=1 union select id,title,info,author from dt2 where id=1绑定上去就是
如果表一、表二是两种类型的数据 select id,title,info,author,'娱乐新闻' type,'a.aspx?type=1&id='||id url from dt1 where id=1 union select id,title,info,author,'体育新闻' type,'a.aspx?type=2&id='||id url from dt2 where id=1这样不就区分开了
union
select id,title,info,author from dt2 where id=1绑定上去就是
select id,title,info,author,'娱乐新闻' type,'a.aspx?type=1&id='||id url from dt1 where id=1
union
select id,title,info,author,'体育新闻' type,'a.aspx?type=2&id='||id url from dt2 where id=1这样不就区分开了