Hey guys
what is the best way to join a table like this let say I’ve got a table Towns with a pkID and TownName field. And I’ve got a table named Destination with a pkID, DepartureID, DestinationID. Now destination and departure obviosly refer to the towns pkID field.
So how do I join these that If there is only 100 records in the Destination that only a 100 show with the names of the towns and not the nombers