
加好友 发短信
等级:超级版主
帖子:112364
积分:572076
威望:0
精华:9
注册:2015/6/24 9:21:00
|
Post By:2020/11/14 14:43:00 [显示全部帖子]
提示什么错误?试试
select pzzb142 from dtpzzb where pzzb142 in (select DISTINCT left(pzzb43 ,(inStr(pzzb43,'拆') - 1)) as pzzb142 from(select pzzb43 from dtpzzb where pzzb43 like '%拆%')as a)
|
|