[导入]案例20080220 列出台籍人员全年出勤

select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200701 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200702 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200703 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200704 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200705 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200706 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200707 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200708 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200709 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200710 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200711 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200712 where bmmc like '%台籍%'
 
order by no

［此帖子已被 fzonet 在 2008-2-23 21:29:36 编辑过］
文章来源:http://bbs.fzonet.com/rcds/ShowPost.asp?ThreadID=1633