7,713
社区成员
发帖
与我相关
我的任务
分享
select a.hyh,b.xm
from a left join b on (a.hyh=b.hyh)
where (a.delflag <> 1 or a.delflag is null)
and b.rq >= '2007-12-28'
iif(len(rtrim(a.delflag)) <1,0,a.delflag) <> 1
a.delflag <> 1
select a.hyh,b.xm
from a left join b on (a.hyh=b.hyh)
where iif(len(rtrim(a.delflag)) <1,0,a.delflag) <> 1
and b.rq >= #2007-12-28#
b.rq> ='2007-12-28' ?
b.rq >= #2007-12-28
select a.fd1,a.fd2,b.fd1,b.fd2
from a left join b on (a.fd1=b.fd1) and b.fd2 <> 1 where a.fd2> 0