SELECT table1.column FROM table1 INNER JOIN table2 ON table1.primary_key_column = tabl2.foreign_key_column;