You can try writing the query like this:
SELECT Table_one.Name, Table_two.weight FROM Table_one JOIN Table_two on Table_one.identifier == table_two.identifier