MySQL - Select rows with id from another table

[PloMar]

I have the following Select in MySQL:

Code: Select all

$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?

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

Code: Select all

$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.