match pattern join

amiroh81 — Sun, 22 Apr 2018 14:51:24 GMT

Hi,

I want to join between two queries when the connection between them will be in the style of match pattern.

For example :

Lines 1 and 3 have the same 2-digit prefix.

What I would like to see is that the first line will be connected with the first row and the third line will be combined with the third line only.

This means that no connection will be made between the third line and the first row 124444 <> 1 , 124444=1244

I hope I've been able to explain the problem

thanks in advanced

Re: match pattern join

MarcoWedel — Sun, 22 Apr 2018 16:39:13 GMT

Hi,

one solution could be:

Edit: Removed solution and waiting for you to first close your open threads that received correct answers: amiroh81

thanks

regards

Marco