Postgres Pro
Downloads
Home   >   mailing lists

Question on joining tables - Mailing list pgsql-novice

From Chris Pizzo
Subject Question on joining tables
Date
Msg-id 00a101c20b1e$d342f3e0$832aa8c0@itchrisp
Whole thread Raw
Responses Re: Question on joining tables
List pgsql-novice
Tree view
Hi,
I have an interesting issue where i need to join two tables where the field that jions them is similar but not identical.  Table A field data is char(12) and contains data that looks like:
 
BBB12345
BBB345
BBB4980
BBB3455
 
Table B field data is char(32) and contains data that looks like:
 
MMM12345
BBB345
BBB4980
MMM3455
 
I need a way to equate  MMM12345 to BBB12345 in the join.  I tried using substrings but this fails ie.
 
select some_data from A,B where (substr(A.field,4,12) = substr(B.field,4,12));
 
anyone point me in the right direction?
 
Thanks,
Chris Pizzo

pgsql-novice by date:

Previous
From: "Nicolas Bazin"
Date:
Subject: Re: [PORTS] ecpg not found
Next
From: Oliver Elphick
Date:
Subject: Re: Incorrect date/time returned by current_timestamp