union联合查询
SELECT TOP ID,oTitle Title,oInfo Description,Pic Images from Home_Chnu where ischk= AND UpTime > dateadd(day,-,UpTime); SELECT TOP ID,Title,info Description,BigLogo Images from house_spll where IsLine= AND updatetime > dateadd(day,-,updatetime);
union上下列名个数及类型必须一致
union默认将重复数据去掉,如不去 则可使用union all,方法同上
--记录铭心