Yes why not. That is the concept of
Foreign Key[
^].
The other column will be primary key in the other table and will be referenced in the first table as Foreign key.
Refer -
SQL FOREIGN KEY Constraint[
^].
So, depending on that column you can join.
SELECT columnName
FROM
Table1
INNER JOIN
Table2
ON Table1.Column1 = Table2.Column1