like里怎么用子查询呢？

[mm7711]

delete from user where userId like '(select id from employee)%'
这么写执行不了啊？

[kookboy]

delete from user where userId like '(select id from employee)%'
很好很强大,LZ应该学下T-SQL

[jinjazz]

delete from user a where exists(select 1 from employee
where a.id like id+'%')

[chenjidehai]

delete from user where userId in(select id from employee)

[dawugui]

delete user
from user m , employee n
where charindex(n.id , m.userid) > 0

[-狙击手-]

delete a
from user a,employee
where charindex(ltrim(a.userId) ,ltrim(b.id)) > 0

[-狙击手-]

delete a 
from user a,employee b
where charindex(ltrim(a.userId) ,ltrim(b.id)) > 0

[yyyyzzzz_2002]

delete from user a where exists(select 1 from employee  
where a.id like  id+'%')

[internetroot]

改成动态SQL语句是可以实现的

declare @s varchar(200)
set @s=
'delete from user where userId like '''+cast((select top 1 id  from tbexpert) as varchar(8000))+'%'''

exec(@s)

[kelph]

[code=SQL]
delete user from user,employee where user.userId like employee.id +'%' 

[/code]

[wpeng8218]

delete from user where userId like (select id+'%' from employee)