Mysql子查询用limit

执行带有Limit子查询是有问题的：

 

  SELECT * FROM 
    task_and_device  
  WHERE  
    job_id IN
    (SELECT 
       id 
     FROM wx_device_task_job 
     WHERE 
     user_id=79269 AND STATUS=1 
     ORDER BY last_updated DESC 
     LIMIT  20  OFFSET 0)

报了如下的错误：

 

错误码: 1235
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

 

 

需要再加上一层select才能成功：

 

  SELECT * FROM task_and_device  WHERE  job_id IN
			  (	
			  SELECT A.id FROM
			  (
			  SELECT id FROM wx_device_task_job WHERE user_id=79269 AND STATUS=1 ORDER BY last_updated DESC
			  LIMIT  20  OFFSET 0
			  ) AS A
			  )