2,722
社区成员
发帖
与我相关
我的任务
分享
Select *,Iif(Deleted(),.T.,.F.) As scbj Into Cursor gonghuo1 From wanglai!gonghuo
Select Gonghuo1.htbh, Yw.xmmc, Kehu.khmc, Gonghuo1.sxrq, Gonghuo1.htje,;
Gonghuo1.sjje, Gonghuo1.htghrq, Gonghuo1.sjghrq, Rsstrs.xm, Gonghuo1.fkff,;
Gonghuo1.khbh, Gonghuo1.xmbh, Yw.xiaosbh, Gonghuo1.zhibdq,Gonghuo1.scbj ;
From gonghuo1 Left Outer Join wanglai!kehu ;
On Gonghuo1.khbh = Kehu.khbh ;
Left Outer Join wanglai!yw ;
On Gonghuo1.xmbh = Yw.xmbh ;
Left Outer Join wanglai!rsstrs ;
On Yw.xiaosbh = Rsstrs.bh ;
Where &tj;
Order By Gonghuo1.sxrq, Yw.xmmc ;
Into Cursor gh_linshi