select A.item,B.xi,C.yishen,dbo.fgetstr2(C.content,'总科类名') content1,dbo.fgetstr2(C.content,'分科类名') content2
from itemsort A,jbxx B,binli C
where (not C.content='') and (dbo.fgetstr2(C.content,'总科类名')='') and (dbo.fgetstr2(C.content,'分科类名')='') and (C.personalid=B.personalid)
from itemsort A,jbxx B,binli C
where (not C.content='') and (dbo.fgetstr2(C.content,'总科类名')='') and (dbo.fgetstr2(C.content,'分科类名')='') and (C.personalid=B.personalid)
from itemsort A,jbxx B,binli C
where (not C.content='') and (dbo.fgetstr2(C.content,'总科类名')='') and (dbo.fgetstr2(C.content,'分科类名')='') and (C.personalid=B.personalid)
但SQL SERVER中不用直接引用content1,content2
select A.item,B.xi,C.yishen,dbo.fgetstr2(C.content,'总科类名') content1,dbo.fgetstr2(C.content,'分科类名') content2
from itemsort A,jbxx B,binli C
where (not C.content='') and (dbo.fgetstr2(C.content,'总科类名')='') and (dbo.fgetstr2(C.content,'分科类名')='') and (C.personalid=B.personalid)