Clay Clay - 26 days ago 6
SQL Question

Trying to create a join of tables when the words end in the same letters of each word of the table in ACCESS

select a.word,
b.word
from sec1313_words1 a,
sec1313_words2 b
where mid(a.word, len(a.word)) = mid(b.word, len(b.word));


This is what i was looking for thank you

Answer

You can try this:

SELECT A.Id FROM [Table1] AS A INNER JOIN [table2] AS B ON RIGHT(A.Id,2)=RIGHT(B.Id,2)

Comments