Problem using LIMIT in a MySQL subquery?

Question

I have a SQL query as follows

SELECT * FROM epf_application WHERE application_id IN
(SELECT application_id FROM epf_application_device_type WHERE device_type_id IN
(SELECT device_type_id FROM epf_device_type WHERE name="someDevice") LIMIT 30) LIMIT 30

When I run it in phpMyAdmin, I get the following error

1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

From the error, I am guessing that there is a problem with placing LIMIT in a subquery. Any suggestions on how I can fix this?

As the error says, that feature apparently isn't yet supported. You may need to get your hands dirty and use a temporary table or something. — Chris Eberle
– Chris Eberle, Commented Jun 23, 2011 at 15:11
@FinalForm: Indeed, I think David needs to learn a bit about JOINS. — josh.trow
– josh.trow, Commented Jun 23, 2011 at 15:14

josh.trow · Accepted Answer · 2011-06-23 15:17:50Z

1

SELECT 
 ea.* 
FROM 
 epf_application ea JOIN epf_application_device ead 
  ON ead.application_id = ea.application_id 
 JOIN epf_device_type edt 
  ON edt.device_type_id = ead.device_type_id 
WHERE 
 edt.name = 'someDevice' 
LIMIT 30

answered Jun 23, 2011 at 15:17

josh.trow

4,90123 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem using LIMIT in a MySQL subquery?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related