Re: Weird join...

On Mon, Jul 12, 2004 at 12:47:41 +0300,
Costin Manda <costin(at)interpoint(dot)ro> wrote:
> I need to join two tables in postgres (or any other SQL) like this:
> table 1 has a list of phone numbers
> table 2 has a list of country prefixes (like 40 for romania 407 for romania
> mobile, etc)
>
> I want to join the tables so that a number like
> 407111111 in table 1
> is joined ONLY with
> 407 in table 2
>
> Can you please help?

You should keep the country prefixes as a separate column in the table with
the full numbers. It might also be useful to break out area/city code
from the local phone number.
You also might want to store both the IDD prefixes (there can be multiple
ones for some countries) and the NDD prefixes for the phone numbers.