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@interpoint.ro> wrote in message
news:00a401c467f5$464b3980$96b0e6c1@Costin...
>   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