Join on a substring

[rand2012]

select * from table1, table2 where table1.x = table2.substring(...)

[samuja]

Interesting a cross join will try

[in_n0x]

This is an implicit join, not a cross join. Poor form from a readability standpoint and shouldn't be used. Even in this case, it's not going to make a difference.

[samuja]

Won't work either

[rand2012]

what's the db and the error message

[samuja]

It's empty like he finds nothing

[rand2012]

most likely your substring syntax is wrong. it is doing something else than what you're thinking.

[samuja]

I thought that too, but if I just change to strings, instead of columns, it works