Joining tables

Hi ​@Ed22 

How about this one?

SELECT *
FROM table1 t1
JOIN table2 t2
  ON t1.part_no LIKE '%' || t2.part_no || '%';

or this one?

SELECT *
FROM table1 t1
JOIN table2 t2
  ON REGEXP_LIKE(t1.part_no, t2.part_no);

Please try if it fits your requirement.

Hope this helps

Furkan

SELECT *

FROM table1 t1

JOIN table2 t2

ON REGEXP_LIKE(t1.part_no, t2.part_no) this isnt working. t1.part_no = M004787_7000_FRAME_FINAL AND t2.part_no = A-33-M004787_7000_FRAME_FI this wont find

​@Ed22 I’ve had some luck using INSTR.  Although, fair warning, it may be slow and may return some unexpected results if T2 has short part numbers that are contained in the T2 part number. (Like “A”).

Hi,
t1.part_no = A-11-2233_56_FRAME

t2.part_no =          2233_56_FR

what about using (dynamic) substring?

2233_56_FR => 10  from the right side 13 “away”.

SELECT *

FROM table1 t1

JOIN table2 t2

ON

sustring(t1.part_no, -13, 10) = t2.part_no

HTH
Michael

Found on: https://stackoverflow.com/questions/3440849/get-string-from-right-hand-side

substr(STRING, ( length(STRING) - (TOTAL_GET_LENGTH - 1) ),TOTAL_GET_LENGTH)

​@Ed22 , the following should do it

SELECT    1
FROM   dual
WHERE
    regexp_substr('A-11-2233_56_FRAME', '\d{4}_\d{2}') = regexp_substr('2233_56_FR', '\d{4}_\d{2}');