Forum

Posted: **05 Feb 2015, 07:30**

I have the following Select in MySQL:

$sql = "SELECT * FROM table_1 WHERE rank = 2 AND id IN(2, 5, 8)";

But the IDs (2, 5, 8, ...) must be from a Select from another table.
So, how can I select the rows from table_1 with the IDs from table_2?

Posted: **05 Feb 2015, 07:41**

You can use multiple Select statements in the same SQL query.
Try this query, using a sub-select that selects the IDs.

$sql = "SELECT * FROM table_1 WHERE rank = 2 AND id IN(SELECT id FROM table_2 WHERE condition)";

- Replace "condition" with the condition that you want to select the IDs from table_2.

MySQL - Select rows with id from another table