这样的语句是不能执行的
select username,header_url from user where id in(select id from discuss_post limit 0,10 );
但是,只要可以在进行包装一层则可以运行如:
select username,header_url from user where id in(select t.id from(select id from discuss_post limit 0,10) as t);
这样的语句是不能执行的
select username,header_url from user where id in(select id from discuss_post limit 0,10 );
但是,只要可以在进行包装一层则可以运行如:
select username,header_url from user where id in(select t.id from(select id from discuss_post limit 0,10) as t);