I have two tables: t1 and t2.
id item
id index item
index in t2 is a derivative of a static suffix + t1.id
Eg.
t1.id == 4 t2.index == suffix4
Can I join these two tables by these two fields? If yes, how?
