vfp中exists用法?
SELECT * from jk1 a where exists(select * from jk2 b where left(b.dm,6)=a.dm)
在SQL中可以运用,但在vfp中出错“关联字段时出错”
[解决办法]
-- 改为:
Select a.* From jk1 a Inner Join jk2 b On Left(b.dm,6)=a.dm)
发布时间: 2013-01-12 16:25:03 作者: rapoo
vfp中exists用法?
SELECT * from jk1 a where exists(select * from jk2 b where left(b.dm,6)=a.dm)
在SQL中可以运用,但在vfp中出错“关联字段时出错”
[解决办法]
-- 改为:
Select a.* From jk1 a Inner Join jk2 b On Left(b.dm,6)=a.dm)