General discussion
May 17, 2005 at 05:45 AM
francoisv

table join

by francoisv . Updated 21 years, 4 months ago

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

This discussion is locked

All Comments