select b.cif , unique(a.primcn) , b.acctnum , b.incoll , b.primloc , a.cpnum , a.cardstat ,
d.educate ,d.positions
from cardmast a ,acctmast b ,acttxn c ,custmast d
where a.primary_cif =b.cif and b.acctnum=c.acctnum and a.primary_cif=d.cif
and a.cpnum in ('100','101','110','111')
and b.apnum in ('100','101') and b.acctstat!=9 and a.cissue between
'01/01/2004' and '31/05/2006' and d.houstat!=1 and d.houstat!=2 and
d.resstat!=1 ;总是报错:missing expression 不知道问题在哪里 ,谢谢了
d.educate ,d.positions
from cardmast a ,acctmast b ,acttxn c ,custmast d
where a.primary_cif =b.cif and b.acctnum=c.acctnum and a.primary_cif=d.cif
and a.cpnum in ('100','101','110','111')
and b.apnum in ('100','101') and b.acctstat!=9 and a.cissue between
'01/01/2004' and '31/05/2006' and d.houstat!=1 and d.houstat!=2 and
d.resstat!=1 ;总是报错:missing expression 不知道问题在哪里 ,谢谢了
d.educate ,d.positions和
a.primary_cif=d.cif
and a.cpnum in ('100','101','110','111')和
and
d.resstat!=1 ;
是否有空格和乱麻?