Re: Weird join...

Assuming:
table Phone(Number varchar(11))
table Country(Prefix varchar(11), Name varchar(99), ...)

select *
from Phone, Country
where Prefix = (select max(Prefix) from Country where Number like
Prefix+'%')

""Costin Manda"" <costin(at)interpoint(dot)ro> wrote in message
news:00a401c467f5$464b3980$96b0e6c1(at)Costin(dot)(dot)(dot)
> 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