another answer. select * from table_A a, table_B a where a.population = b.population; pick one old or new school :-)

MS-SQL lets assume two tables - City and State each having common column called population here is the join on population field Select * from City Inner join State ON city.population = state.population Done :-)