select name,endtime,zhichu,zhuceshang from yuming
union all
select a.name,b.endtime,b.zhichu,b.zhuceshang
from yuming a join yumingrenew b on a.id = b.yumingid
[/Quote]
好的,我试试看
select name,endtime,zhichu,zhuceshang from yuming
union all
select a.name,b.endtime,b.zhichu,b.zhuceshang
from yuming a join yumingrenew b on a.id = b.yumingid