select * from a where column in (select column from b); pandas code example Example: how to select rows based on column value pandas df.loc[df['column_name'] == some_value]