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:
Table B field data is char(32) and contains data that looks like:
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?
pgsql-novice by date
|Next:||From: Tom Ansley||Date: 2002-06-03 18:48:24|
|Subject: JDBC issue|
|Previous:||From: Chris Pizzo||Date: 2002-06-03 16:50:53|
|Subject: Question on joining tables|