这样一个SQL语言有其他写法吗?
insert into useful
select * from record
where name in (select name from record where address= '10.20.126.65 ' group by name,admin,sex)
and admin in (select admin from record where address= '10.20.126.65 ' group by name,admin,sex)
and sex in (select sex from record where address= '10.20.126.65 ' group by name,admin,sex);
[解决办法]
insert into useful
select * from record
where name+admin+sex in (select name+admin+sex from record where address= '10.20.126.65 ' group by name,admin,sex)
