C
colsnake
Unregistered / Unconfirmed
GUEST, unregistred user!
paradox表的SQL语句有无substring函数,若无,以下sql语句可用什么代替:
select total.dn,total.rq,toatl.st
From total
Where substring(total.dn,1,4) in
(Select jm.jm from jm)
//注:total.dn为7位电话号码,jm.jm为四位电话局码,本sql功能为将total表中所有
前四位局码与jm.jm一致的号码选出
select total.dn,total.rq,toatl.st
From total
Where substring(total.dn,1,4) in
(Select jm.jm from jm)
//注:total.dn为7位电话号码,jm.jm为四位电话局码,本sql功能为将total表中所有
前四位局码与jm.jm一致的号码选出