var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: joining on like instead of =
I am writing a query where I want to join two tables but using like, instead of =.
say the two columns are
left join mytable2 tb2 on tb1.col1 like tb2.col2
the problem is the values in tb2 will contain the value in tb1 so I really need something like
left join mytabl2 tb2 on tb1.col1 like 'tb2.col2%' but in the ' ' , it will be interpreted as the string and not the table name.
what am I missing?
JOIN tb2 ON tb1.col1 LIKE tb2.col2 || '%'