SELECT * FROM table WHERE value = (SELECT * FROM table2 WHERE value2 = ?)