In SQL, an inner join should work, here's an example:
select a.ID, a.Name from TableA a
inner join TableB b
on a.ID = b.AID
a and b are table aliases, and could be written out with the Table Name instead. This example uses the ID in table A (primary key) to relate to the foreign key (AID) in table b.