请问这条SQL语句是什么错误?
请问这条SQL语句是什么错误?  
select   *   from   aaa   where   ljth   in(select   ljth   from   aaa   group   by   lith   having   count(*)> 1);  
这是从aaa表中选出字段ljth有重复的记录,是正确的.但是:我在这条语句的基础上再加个条件比如说   ljmc   = 'sss ',如何写?
select   *   from   aaa   where   ljth   in(select   ljth   from   aaa   group   by   lith   having   count(*)> 1)   and   ljmc   = 'sss ';ljmc是表的字段名   ,这样写是错误的.请问如何写?

------解决方案--------------------
--试试这个--
select * from aaa t where ljmc = 'sss ' and (select count(lith) from aaa where ljth=t.ljth)> 1