MYSQL IN statement with column values from another table

Question

I want to get specific column values from one table and use those values to get information from another table.

I'll use this example: both table1 and table2 contains rows with a "name" column.

I want to select the values of all the "name" columns from table1 meeting conditions and then select rows from table2 which contain any of the names selected from table1. The basic idea is below.

SELECT `name` FROM table1 WHERE...
SELECT `name` FROM table2 WHERE `name` IN(names from the above query)

Hopefully this is clear, thanks.

@KayKay I'm not how you go about SELECTing from one table and using those results to SELECT from another table, all in one query. — user2923125
– user2923125, Commented Nov 30, 2013 at 22:50
While you can indeed do it with a SELECT within the IN clause, it would be much better to do it with a JOIN instead. — Ken White
– Ken White, Commented Nov 30, 2013 at 22:57

kgautron · Accepted Answer · 2013-11-30 22:56:46Z

1

Just "inject" your first query in the second :

SELECT name FROM table2 WHERE name IN(SELECT name FROM table1 WHERE...)

answered Nov 30, 2013 at 22:56

kgautron

8,34510 gold badges42 silver badges61 bronze badges

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

Comments

Filipe Silva · Accepted Answer · 2013-11-30 23:34:14Z

0

Apart from the answer from KayKay you can also use EXISTS:

SELECT name FROM table2 t2
WHERE EXISTS( SELECT 1
              FROM table t1
              WHERE t2.name = t1.name)

answered Nov 30, 2013 at 23:34

Filipe Silva

21.7k6 gold badges56 silver badges70 bronze badges

Collectives™ on Stack Overflow

MYSQL IN statement with column values from another table

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