Nested Select in mysql

Question

Is it possible to create a nested select statement something like this in mysql?

SELECT * from myTable WHERE id = (SELECT id from data where dataId = 1);

If this is not the correct way to formulate such a statement could anyone point me in the right direction for the way in which it should be formulated.

Thanks

IT ppl · Accepted Answer · 2012-04-09 10:36:20Z

1

SELECT * from myTable WHERE id IN (SELECT id from data where dataId = 1);
                                ^---- You should use in rather than =

edited Apr 9, 2012 at 10:36

answered Apr 9, 2012 at 10:29

IT ppl

2,6472 gold badges41 silver badges57 bronze badges

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

Comments

Jim · Accepted Answer · 2012-04-09 10:30:42Z

0

This syntax is fine. Note though that this will only work if there is one data with dataId 1. If there is likely to be multiple ids returned by the inner select then it is better to use:

SELECT * from myTable WHERE id IN (SELECT id from data where dataId = 1);

answered Apr 9, 2012 at 10:30

Jim

22.7k6 gold badges55 silver badges81 bronze badges

Collectives™ on Stack Overflow

Nested Select in mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related