Re: Weird join... - Mailing list pgsql-novice

From Mischa Sandberg
Subject Re: Weird join...
Date
Msg-id V4AIc.25685$Rf.15828@edtnps84
Whole thread Raw
In response to Weird join...  ("Costin Manda" <costin@interpoint.ro>)
List pgsql-novice
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



pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Assigning a return value from a function to a variable.
Next
From: Betsy Barker
Date:
Subject: Re: Assigning a return value from a function to a